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
Related Forum Messages:
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?
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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?
View Replies !
DB For Directory Service
I am creating a new database for a directory service. I have thousands of records, and every record has one suburb (out of 35). %90 of the records has also one district name (district is a small suburb, every suburb has around 3-10 district) Some of the records have two districts. (one record can have maximum one suburb and two districts.) Suburbs and districts are constant, so I won't be adding any new records for them in the future. When visitors search something from the directory, they will enter either one suburb name or district name. What I have thought is that I would create a table which has suburb, district1 and district2 columns. If someone search something, I will compare the location in the script, if it is a suburb, then I will only search it from the suburb column, if it is not a suburb then I will search the district1 and district2 columns.
View Replies !
Database Directory
I have some trouble understanding the workings of the DD tables, and found very little information online. I understand WHAT the DD is, but not it's precise structure. I was wondering whether anybody knows of any resources that may help me understand the system DD table's structure, and they work (e.g. which tables are used when evaluating expressions, which tables are checked for user permissions etc).
View Replies !
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.
View Replies !
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:
View Replies !
MySQL Root Directory
I am using flex for interface, java for intermediate code and mysql for DB. My website contains videos so instead of uploading them on db, i have instead put a path in db and stored videos on machine. the path is '/images' for images and '/video' for videos. Before I was using IIS server and when i used to put my index.html (along with .swf and .js) file and 'images' and 'video' folder in /inetpub/wwwroot folder, it used to work fine. now i am working with tomcat, and i have tried placing 'images' and 'video' folder everywhere but its not working. I am sure that database is connected because there is some info of videos stored directly in database that i get.
View Replies !
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.
View Replies !
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:
View Replies !
Hidden Directory FOUND.000
using MYSQL on my linux device , MYSQL has been installed on the CF Card. THe problem that i am facing is that whenever some data gets written on to the database there is a Hidden forder called as FOUND.000 which gets created and starts occupying the memory space. I found the folder when i used the CF Card with Card reader and saw the contents of it through windows. But my application is running in Linux and hence i dont know how to delete the folder at runtime since it is hidden. Can anyone suggest a way to do it. Or is there any command which will disable the creation of the folder.
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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.
View Replies !
Change Database Directory On Windows
I tried to move the default data dir to my data drive, because this is different from the system and program drive.But it seems that on Windows there is no possiblity to change this. Every time I try it the mysqld-nt service does not start.I can not belive such behavior! I it really true that on Windows you can't change the database location?
View Replies !
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.
View Replies !
Changing Data Directory On CentOS 5.2
I want to change mysql's data directory from default location(/var/lib/mysql) to "/home/mysql" I have copied all the data from default directory to "/home/mysql". and Changed the ownership to the 'mysql' user. Modified the /etc/my.cnf specifying the desired data directory. when i tried to start the mysql service i got the following error "Starting MySQL.Manager of pid-file quit without updating fi[FAILED]" the logfile details are 081009 18:10:55 mysqld_safe Starting mysqld daemon with databases from /home/mysql/ 081009 18:10:55 mysqld_safe mysqld from pid file /home/mysql//localhost.localdomain.pid ended I am running mysql on CentOS 5.2 VMWare. I have tried the same procedure on FC 6 VMWare and succeded.
View Replies !
Image Store In Db Or Directory Using Dreamweaver Cs3
Please help me solve a problem regarding image upload using deamweaver. i don't undestand how DW. genarates its codes for inserting articles in DB. My problem is that the code that DW.creates is complex for me to undestand where it uses Getvalues and getthetype. I don't know where to declare the values and the type of the $_files.thanks
View Replies !
Customized Database Directory Structure
The default database location is usually located on the %datadir%/databasename folder, where datadir is a string inside the my.ini file. the datadir will usually have the value "%Application Data%/MySQL/MySQL Server 5.1/Data/". Since I am thinking about offering a SaaS solution to my customer, I want to have my database directory slightly different. I want to have my database in the folder %datadir%/%companyname%/%databasename%. where the %companyname% is determined from the URL, i.e., %companyname%.mycompany.com is the URL for one of my customer.
View Replies !
Resolving Spaces In Directory Names In My.cnf
I am using MySQL 5.1 on Mac OS. I have moved my log-bin to a new location - /Apps Data/mysql/. I have set the same in the my.cnf file but MySQL fails to start and the error flagged is 'File Not Found'. I have tried with the following in my my.cnf - [mysqld] log-bin = '/Apps Data/myql/mysql-bin.log' ... [mysqld] log-bin = /Apps Data/myql/mysql-bin.log ... [mysqld] log-bin = /AppssData/myql/mysql-bin.log ... Does MySQL fails to resolve spaces for its directory names?
View Replies !
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.
View Replies !
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 ...
View Replies !
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).
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
Libmysqlclient_r.so.16: Open Failed: No Such File Or Directory
I started building my test app using the linker line LIBS = -I/opt/mysql/mysql/include -L/opt/mysql/mysql/lib -lmysqlclient -lsocket -lnsl -lrt -lpthread but changed over to LIBS = -I/opt/mysql/mysql/include -L/opt/mysql/mysql/lib -lmysqlclient_r -lsocket -lnsl -lrt -lpthread to try and make my application "thread safe". When I run, I am getting an error on the console: ld.so.1: mysql_thread_example: fatal: libmysqlclient_r.so.16: open failed: No such file or directory Killed It is really not even getting into 'main'. Here is my complete Makefile: PROGRAM = pthreads.c OBJS = $(CSRCS:.c=.o) CSRCS = pthreads.c CC = gcc LINKER = gcc CFLAGS = -Wall -m64 -O3 -mtune=k8 -g LDFLAGS = -m64 LIBS = -I/opt/mysql/mysql/include -L/opt/mysql/mysql/lib -lpthread -lmysqlclient_r -lsocket -lnsl -lrt all: $(PROGRAM) $(PROGRAM): $(OBJS) $(LINKER) $(LDFLAGS) $(OBJS) $(LIBS) -o $(PROGRAM) $(OBJS): %.o: %.c %.h $(CC) -c $(CFLAGS) $*.c clean: rm -f $(OBJS) $(PROGRAM) Finally, I tried this with the sample program posted in 28.2.16 "How to Make a Threaded Client", and it dies the same way.
View Replies !
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
View Replies !
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?
View Replies !
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.
View Replies !
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
View Replies !
How To Write A Trigger
we have an invoice table with fields ( invoice_id,date, item_id,item_name, price_per_item,quantity,cust_id) here (item_id ,item_name and price_per_item) are from table item_details. now i have to write a trigger to track the users who have changed the price_per_item column before insertion in invoice table.
View Replies !
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?
View Replies !
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?
View Replies !
How To Write Trigger
want to copy the table data from one host to another host why because its live data . i want to update one host to another host. ie i have one host 192.168.1.1 (db name is EXample table is live) i want to copy the live table values into another table which is located in different host ie(192.168.5.5 db name is Datadummy and table is livedummy). in triggers is it possible or not?
View Replies !
Cannot Write To Database
The result I am getting is: request "Could not execute SQL query" SELECT dt FROM webcalendar_events WHERE dt in ('2009-03-13') AND calendar_id=cum_wetheralhalls FOR UPDATE Unknown column 'cum_wetheralhalls' in 'where clause' The strange thing is that when the calendar_id is a numeric value, it works perfectly. Is there anything that I can do in MySQL to get this to work with text-characters also, or do I have to use numeric values for this? Is this something in the PHP script that is preventing it from saving to the database? In case you need to know the table row calendar_id is varchar(30).
View Replies !
|
TRACKER
