Using INSERT To Write To A Directory
I have a problem that I'm not sure if it can be done. I'm trying to
use the MySQL C API to be able to use a normal sql insert statement
that will send the data or file to a directory and NOT the database.
I'm not sure if there is anything out there that will allow this, but
I've searched everywhere, and I have found no solution.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
No Read Or Write Between INSERT And UPDATE
I am using mysql with the InnoDB engine. I wrote a perl script that first selects something from a table, and then updates a second table based on the select from the first table. I need to make sure that there is no read or write to the tables while my script performs the insert and update. I looked at http://dev.mysql.com/doc/refman/4.1/en/lock-tables.html and it says this: --------------------------------------------------------- If you are using a storage engine in MySQL that does not support transactions, you must use LOCK TABLES if you want to ensure that no other thread comes between a SELECT and an UPDATE. The example shown here requires LOCK TABLES to execute safely: LOCK TABLES trans READ, customer WRITE; SELECT SUM(value) FROM trans WHERE customer_id=some_id; UPDATE customer SET total_value=sum_from_previous_statement WHERE customer_id=some_id; UNLOCK TABLES; Without LOCK TABLES, it is possible that another thread might insert a new row in the trans table between execution of the SELECT and UPDATE statements. --------------------------------------------------------- However, I am using InnoDB and it DOES support transaction. So, does that mean that even if I don't lock my tables, it will still work? If not, what do I need to do?
Search And Write, Or Write And Recover?
The problem: I need to generate a 'unique string' for each row in a table. I already use auto_increment for system dependencies between tables. What is the best approach one of these or another? After generating a candidate 'unique string' the two strategies that came to mind are: 1. to then search the table's column to see if it is already assigned; locking the table for write while searching and writing the new row, or 2. set the column to UNIQUE when defining the table. Just go ahead and write the new row if you get a "non-unique" exception, generate another 'unique string' and try again. I've tried both on a small XP laptop and get "lock timeout exceptions" rather quickly using #1. But replace those with lots of re-writes when there starts to get "collisions" of 'unique string's.
What Directory For Basedir ?
What should i set my basedir to ? I thought /var/lib/mysql would work. I am trying to run /mysql_upgrade script but it keeps on bitching about the basedir - can't find the mysql command line client. Which file does this refer to ? Code:
NAS Vs SAN For Data Directory
I am trying to decide which storage I should use for the "Data Directory". My application has lots of 'SELECT's (80%) and fewer UPDATEs/INSERTs(20 %). I have the following choices of Data storage 1) Xiotech SAN (66 Mhz FCAL) 2) NAS 3) Internal SCSI 3 RAID 5 Will I achieve any better performance using one storage vs the other storage? In the past (for about 2 years), I have I used SAN with 33Mhz FCAL, and the performance has been quite exceptional. And I have encountered no problems.
Directory Name Invalid
For testing purposes I have PHP installed and I have MySQL installed on my local laptop. Windows XP Pro I am just learning both of them. I have read quite a few chapters in the MySQL Manual. Enough to allow me to get around in MySQL and directly create tables an view information in them, upload .txt files into the tables, etc etc. I am receiving an error when I try to connect to MySQL via a PHP script. I have no problem connecting to MySQL via Command Line. The error I receive is "The directory name is invalid." Here is my code... I am not sure where to put the directory name or where to put the directory path in order to make it valid. I am not sure what directory it is talking about. <html> <head><title>Connect to MySQL</title></head> <body> <?php //connecting to the mysql server uses a mysql_connect command. $link = mysql_connect("locoalhost",$_POST['username'],$_POST['password']) or die("Connect Error: ", . mysql_error()); echo 'Successfully Connected. '; mysql_close($link); ?> </body> </html> Where exactly would I put the path to the directory or where would I name the directory?
Filerights To Certain Directory
How can I give(grant?) the mysql database rights to write in directory /opt/guide/www.domain.com/HTML/upload/test How should I set my rights. A local user 'userA' should have the rights. How should I set these privaliges without opening the gate for everybody?
Membership Directory
I know this is probably a dumb question for all the experts out there. But I have to ask because I'm trying diligently to work at home and want to be successful. How difficult is it for someone with an Access background and pretty fair understanding of differing programming lagnuages to build a member directory that currently house 16,000+ members. The client wants it done by 8/1. I have yet to sink my teeth into a real web database, shall I take the chance? I'm a quick study and have taught myself most of what I know. I've basically gone to school to learn little things I've missed to Ace a class on something I already know, but is mandatory for my degree.
Working In A Windows Directory...over The Web
Is there a way to set up a database so it reads a windows directory? Like the W:/ drive? Or have a function that moves files from W:/ to C:/? and then have this functionality over the web? Where do I start? I want this to be simple but all the resources I find are complex or more toward website stuff. I’d like to develop the frontend with PHP and have it interact with VB as well.
Errcode 17 In Temporary Directory
I run a web server (on IIS) with a big site on it. It has php5, mysql 5 and odbc 3.51 It has 640MB of ram. at random times I get this error (not always the same file, but similar): [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-log]Can't create/write to file 'C:EasyPHP mp#sql_3fc0_0.MYD' (Errcode: 17) If I go to that directory and delete that file, the problem disappears. But until I do this the pages display a mysql/odbc error and nothin works. So if it happens at night or when I'm out, my website will remain down for a lot. Really annoying problem!! I googled the errcode 17 and found out that it can be caused by: - directory permission problem > this is not my case, I've given correct permissions - an antivirus performing a scan in the temp directory > this is not my case So what is this?! Code:
Create A Directory-search
I'd like to create a form to search in my database that is a directory. It contains an important list of persons with their names, firstnames, telephone numbers etc. Do you know where I could find a script to help me? I'd like to create a multi-criterions form.
MySQL Or Directory Tree?
I'm working on a project where I have about 5 different data structures (objects) consisting of about 15-30 fields each. The size of each object is about 2-4 kB. The maximum number of objects will be in the range 5000-100000 for each object. I need possibility to search, add, delete, update and get these objects by ID, NAME, DATE and VERSION only. I have no need for the individual fields of the objects only complete objects as binary files. When I work with the objects I need access to roughly 5-10% of the objects at a time. Right now I have all these files in a directory tree under Windows XP with ID, NAME, DATE and VERSION included in the file name. I can do all I need but it becomes too slow sometimes. Now to my question: Can I benefit something from moving to a MySQL database when it comes to performance and speed and how should I set up the datbase to make it as fast as possible?
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that.
Creating A Community Directory
The goal is to create entries for a Community Directory: Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Child2 Child3 Using the following code I've been able to get close, but the records are repeated for each entry in the fam table: select concat(hld.l,' ', hld.f,' ', hld.sp,' ', hld.ad,' ',hld.city,' ', hld.st,' ', hld.zip,' ',hld.ph,' ', fam.ff,' ', fam.rel,' ') from hld, fam where k = fk order by hld.l, fam.rel Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child1 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child2 Smith John Sally 8786 Regional Way Somewhere, OR 97224 Child3 Obviously, I need a way to collect these multiple records into one record like the initial sample above.
Arrays And Altering Directory
I am new to this forum. I intend to share my knowledge of MySQL wid everyone here and also gain more than wat i can share. My queries are: 1.Does MySQL provide arrays. 2.Can i change the directory which stores the databases that are created by the user. Besides Pls check www.mysql.com homepage abt a security alert regardin MySQL on Windows. there is sum worm call UDF........anyways i hope to obtain a reply soon.
Change Database Directory
I have a linux server and i installed mysql . it's working fine. But i want to change the mysql database dirctory from /var/lib/mysql to /db/ how can i do that
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
Optimizing A Large Phone Directory
I have a table with names and contact information for a bunch of people (we'll call it a phone directory -- it's not, but confidentiality prevails ). To get twenty people to display on a single page, I'm using this query: SELECT * FROM people ORDER BY lastName LIMIT 20 Pretty straightforward, but for some reason, with a few hundred thousand rows, this is taking a very long time (and I do have an index on lastName, which doesn't seem to help). Is there anything I can do to speed this up? Also, would it be quicker to have separate firstName and lastName lookup tables with firstNameId and lastNameId columns, using this query: SELECT p.*, f.name as firstname, l.name as lastName FROM people p LEFT JOIN firstNames f ON f.id = p.firstNameId LEFT JOIN lastNames l ON l.id = p.lastNameId ORDER BY l.name LIMIT 20 Unless there's some obvious problem or solution I'm overlooking, the only other thing I can imagine is having ANOTHER table with the alphabetical order of the last names, which might speed things up but seems somewhat unwieldly (though doable, if necessary, since I won't be adding people too often). Hopefully there's some simple problem I'm not seeing (which may be, since it seems like MySQL should scale better than this).
Dropped A Database, But It's Still Showing Up In The Directory
I dropped a database used for practice. Although all the tables are gone, the empty database itself is still there. Is this correct? How do I get use of this empty db? Note: I'm using Mysql version 3.23.49 -nt and I also use mysqlfront although I generally use the command line to work with the dbs.
Storing A Directory Type Structure
I have a requirment to store a directory/group type of structure in a database I have an existing table of items for which i need to be able to store group information in the manner similar to the following: group 1 subgroup 1 subsubgroup1 item1 item2 item3 subsubgroup2 item4 item5 item6 subgroup 2 item 7 item 8 item 9 group 2 item 10 item 11 item 12 The problem i am having is that an item can be in any level of subgrouping and the total level of subroups is undefined.
Move Database In Windows To Different Directory
How do I move a database on a Windows 2000 server box. I have MySQL and found where to point the database in the MY.ini file but I cant seem to move it to another partition. If I change the path in the my.ini file the mysql service fails to start. Any help would be greatly appreciated. I have seen how to do this in unix and linux on this forum but could not find a thread on how to do it in Windows.
Change MySQl Data Directory
I moved the data dirctory to a network drive.... this is why it's not working Is there a way to house the data directory off a networked drive/share?
Moving Data Base From / Var To Home Directory
I'm successfully running MySql under Debian with the data files in /var/lib/mysql. I would like to move the data base files to my home directory and have mysql use them from there. How do I do it? Can I just copy them to my home directory and start mysql with a parameter which point to the new locaion? Can I do that with mysql starting at boot time? I just looked at /etc/init.d/mysql and see that it appears to starts mysql by calling /usr/bin/mysql_safe but there is no such file. As an alternative to putting it in my home directory, I would be happy putting the files in /usr/local. Can I do that without rebuilding mysql? The reason I want to do this is that I want to install a new version of Knoppix and that will format and clean out the / partition and I don't want to loose the data I have in /var/lib/mysql. Could I just save /var/lib/mysql and restore it after installing the new version of the system?
How Can I Protect Databases Externally In The Data Directory
My question is how can i protct databases in the data directory externally? Anyone can copy data from the data directory in mysql server and paste it to another system where another mysql server with same version is loaded. If network security is tightened, still this problem will be there. Because hard disk can be removed and data can be stolen very easily in that case. So is there any solution for this?
Cannot Start Database After Relocating The Data Directory
an error after I have relocated my data directory.I found the pid error-log file "bsd19.err" in the previous data directory and it wrote the following every time when I tried to start my database. [Error]/usr/local/libexec/mysqld: Can't create/write to file: /usr/local/db2 (Errcode: 21) [Error]Can't start server: can't create PID file: Is a Directory I also have "chown" the user as mysql on that directory /usr/local/db2 before I start my database.
Home Directory For Load Data Local Infile?
i have mysql installed in the following directory: C:Program FilesMySQLMySQL Server 4.1 i wish to import a file using this command: load data local infile 'Data_Nov06CG1.X001' into table Nov07_File FIELDS TERMINATED BY ' ' LINES TERMINATED BY ' '; but i keep getting this error: ERROR 2 (HY000): File 'Data_Nov06CG1.X001' not found (Errcode: 2) i tried putting this file in the 'data' folder and the install directory. What am i doing wrong? I have a database called 'all' that i'm using for these tables, should i put it in that database folder?
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
InnoDB: Page Directory Corruption: Supremum Not Pointed To
I was prompted to use the "Stop/Start Service" feature in MySQL Administrator and could not re-start the MySQL Server. I have been given a bunch of advice on how to get it started again like using the command prompt in XP Pro. I did and input "mysqld --standalone", it didn't get MySQL Server started. I was told to check the error log, this is what I found... 050515 11:08:37 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050515 11:08:37 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 47130. InnoDB: Doing recovery: scanned up to log sequence number 0 47130 InnoDB: Page directory corruption: supremum not pointed to 050515 11:08:37 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex It seems that the "sepremum" is not pointed to the file it should be pointed to. I don't know what the "sepremum" or if it's preventing MySQL Server from starting.
Help Me Write This Join?
Hi there, been ages since I wrote any sql, and I'm a little stuck but I figure this is easy for you folks. I have this original query: $posts = $wpdb->get_results("SELECT ID, post_title FROM " . $wpdb->posts . " WHERE post_status='publish' ORDER BY post_date DESC"); And this gives a lists of all posts. However, I want to only grab posts by a certain category now, say category #9. This information is kept in an intersection table called wp_post2cat. The columns in that table are: rel_id post_id category_id category_id is what I want, and post_id is the key pointing back to the original post. Posts can have multiple categories, but I just want the one listing where it's category 9, which is audio. So pseudocode would be something like: SELECT all posts WHERE post_status equals "publish" and the category is equal to audio (9).
How To Write This Select?
I'm having some troubles writing a select. I have the following tables: theater ------- - id - name movie ----- - id - name showtime --------- - id - theater - movie - from - to - schedule I would like to list all the theaters with all the available showtimes and movies. I tried to, but i didn't get the result i was expecting. Can somebody help?
Best Way To Write This Query
Query 1: obtains results in boolean mode from products table based on keywords Query 2: Would like to grab all manufacturers names from manufacturers table based on mf_id in products table to then create a brand filter. What is the best way to do this in the most efficient query possible. I was thinking of building a php array from query 1 of mf id's and the putting them in query 2 and separating them using OR operators. any ideas? here is the query fyi: PHP $sql = "SELECT products_id as prodid, products_name as name, manufacturers_id as manufacturers_id, products_price as price, products_msrp as msrp, products_date_added as pda, products_status as status, products_sku as sku, products_weight as weight, categories_id as cat_id, " .boolean_sql_select( boolean_inclusive_atoms($search_string), $fulltext_key)." as relevance " ."FROM $table_name " ."WHERE " .boolean_sql_where($search_string,$fulltext_key)." " ."HAVING relevance>0 "; if (isset($HTTP_GET_VARS['sort'])) { if ($_GET['sort']=="brand") { $sql.="ORDER BY products_name "; } elseif ($_GET['sort']=="size") { $sql.="ORDER BY products_weight "; } elseif ($_GET['sort']=="price_low") { $sql.="ORDER BY products_price ASC "; } elseif ($_GET['sort']=="price_high") { $sql.="ORDER BY products_price DESC "; } elseif ($_GET['sort']=="fav") { $sql.="ORDER BY products_name "; } } else { $sql.="ORDER BY relevance DESC "; }
How To Write This In MySQL?
I Want to check if a certain value doesnt exist in a ceratain field in my table as a condition. "select id from employees inner join translog on employees.emp_id=translog.empid inner join outofofficedays on employees.emp_id=outofofficedays.emp_id inner join holidays where (here is my question: ��-04-02' doesnt exist in the column translog.vtransdate) and (��-04-02' not between holidays.H_START and H_END) order by translog.vTransDate,employees.emp_id limit 1"
How Do I Write This Trigger?
I’ve been searching all over for the answer to this one. If you have the answer, it would help me out a lot! Using MySQL triggers, I want to sync content between two tables; I have table “user” and table “users”, each have similar columns “last_name” “first_name” “user_id” …etc, and when a row gets written to table “users”, I wanted that record to be replicated and inserted to “user” (with all the same field info). How do I write this trigger? I know, it’s anti-normalization, but it will really help me out with testing one of our site's authentication.
Write A Mysql Db Onto A Cd
how to write the db of a mysql on one system onto a cd so as to copy that db to the mysql on another system. The 2 systems are not connected to each other.
Can't Write To File
Using MySQL 4.1.11-max on OS X 10.3. Using command line. Can't successfully use "INTO OUTFILE". Getting the following: mysql> select * -> into outfile '/users/steves/desktop/test.txt' -> fields terminated by ',' -> from industry; ERROR 1 (HY000): Can't create/write to file '/users/steves/desktop/test.txt' (Errcode: 13) At the shell, I get this: steves2ndmac:~ steves$ perror 13 OS error code 13: Permission denied Newbie in both Unix shell and MySQL. Can anyone tell me how to set permissions for Unix User mysql?
Cant Write Or Delete
I cant get my php script to insert or delete records into a mysql table. I can view them all fine but that's about it. I've checked the user permissions on mysql and have set them all to 'Y' incase that was the problem but still no joy. Can anyone suggest what the problem may be? I'm tried the usual RTFM but cant spot the problem
Write Data To Row With Via C API
I have an app written in C that sends data to text files. The files receive 8 variables and look like this: May 19 20:42:09 2002 7 Services 3.23 4.34 0 None 2.31 Rather than writing data to a text file, I need that data to go to a MySQL 5.0.41 database row. I've already got the C API working and connecting to the "localhost" database, but now I need to write data with each transaction. Optimally, I'd like to send the data directly to the database row, but there doesn't seem to be an INSERT statement to do that. What's the best method to write the data to the database directly?
Which Is The Right Directory To Backup MySQL Database On Linux Opearing System?
Implemented web application using MySQL to maintain inventory of the office PC's/laptops/Routers/hubs and other stuff, here we are using MySQL as back-end Database on Linux Operating system. I need to backp all these Inventory database into CD/Tape/Floppy, which is the right directory (MySQL database) to backup (incase if the current MySQL server crashes, then I should be able keep copy of my inventory),
How To Write Like Comparison In Procedures?
this sample procedure takes in an username, searches for number of entries matching the pattern of the username. delimiter $$ create procedure sampleDB.sampleProcedure( IN m_username varchar(30), OUT m_username_matched_count int ) deterministic begin if length(m_username) = 0 then set m_username = 'jason' #set temporary name if empty end if set m_username_matched = 0; #finds number of matches for the given username select count(*) into m_username_matched #store into the variable to be returned from sampleDB.sampleTable where userName like '%m_username%' #this is the statement that does not work# end$$
C- Program To Write To Myi , Myd File
is it possible to create a myi, myd file for mysql using a C program. I am using Stata that is written in C API, and I want to write the data out to MYSQL database. Using ODBC and loading the data in MYSQL from STATA takes forever. Can anyone please tell me if I can create the myd files by using the data in memory thru C programming.
Cant Write Or Delete To Table
I cant get my php script to insert or delete records into a mysql table. I can view them all fine but that's about it. I've checked the user permissions on mysql and have set them all to 'Y' incase that was the problem but still no joy. Can anyone suggest what the problem may be? I'm tried the usual RTFM but cant spot the problem
MySql Write Vs Read
Essentially I am faced with a design choice; have an oft run (modifiable) query run every time any user wants to run it, comparing criteria againt each and every user in the table and delviering list OR saving that list (user/user/) so the next time all that needs to be queried is the existence of a record in the table. The basic tradeoff; version 1 there are many simultaneous queries of the user db on complex search criteria; version 2 there are fewer but their are as many far more simple queries to a much larger table, not to mention many writes to same to keep the table current. I know this is pretty vague, but I was wondering if in general there is an area that mysql excels in vis a vis complex query smaller tables simple query larger tables. Question 2 is there anyway to guestiate the search/write times of a user log in to both query and update? #Records, fields, etc? I'd like to keep log in to < 10 seconds max.
Write Conflict Error
I have a database with access as front end and Mysql as back end. I am gettting the following 'Write Conflict' Error. when i am on my order form, This form does has a subform where i enter all the products that are ordered. Could any one let me know what could cause this problem. I am the only one using the database as its still in the build stage Code:
Slow Write Speeds
Here is what i have IBM x226 - 8GB ram - 2x 3.4 Ghz Xeon (single core) processors - RAID 5E (6x300GB disks) Suse Linux 9.0; MySQL 5.0.13 So, I am migrating from SQL server 2000 on a much smaller Dell PowerEdge (2gb ram, 2 Xeon 3.0 Ghz, Raid 5 over 5x74GB). I am exeriencing very slow write times. For instance, there is one table on both servers that has approx 9mil rows...here is a basic test: Update loan set test_col = 1; Platform Time IBM/Linux/MySQL 5 9:45 Dell/Win/SQL server 1:37 The tests were run during very light server activity and I tried them multiple times. Our IT department is fairly insistant that the IBM server is running per spec...obviously something is not right. I have changed some of the server variables with no improvement.
|
TRACKER
