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.
View Complete Forum Thread with Replies
Related Forum Messages:
Redirect Out Of Mysql Client Program To A File
I have mysql on MS Windows2000. I like to redirect the output/error messages of MySQL client programs to a file. For example, when I execute: "mysql --user=root --password=[wrongpaswd] --silent --database=mysql > errfile" The following error message is coming in the screen, not in 'errfile' "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" I also need to capture the same for utility "mysqlimport". How capture the output of these client programs in a file?
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 !
Create/write To The File
I am working on Solaris and seem to get the following error Cant create/write to the file '/home/dslab456/temp/tempoutput.lst' As in windows i cannot specify which drive it is or so ? could anyone help me out with this ? SELECT * INTO OUTFILE '/home/dslab456/temp/tempoutput.lst' FROM stocklist_vokus s,p_tmpr p WHERE s.STOCKLIST =p.stocklist_value ORDER BY p.rid Edited 1 time(s). Last edit at 02/12/2007 05:38AM by summer queen.
View Replies !
Re-write Text File
i'm creating a log file regarding database operations. My problem is i want to append a new record into the log file each time i update my database. Previously I've used the following method to create a file: SELECT * INTO OUTFILE 'c:/"+fileName[i]+" ' FIELDS TERMINATED BY '|' LINES TERMINATED BY ' ' FROM "+tableName[i]+"; MY problem is I cannot re-use the file created. Is there any way to call the same file for the purpose of re-use. Or maybe the OUTFILE do not allow file created to be re-use.
View Replies !
Can't Create/Write To File
#1 - Can't create/write to file 'AC Web Ultimate RepackServer mp#sql_dac_0.MYI' (Errcode: 2) I am using Wampserver and I am creating the database using myphpadmin. I installed the AC Web Ultimate Repack for World of Warcraft, but since then it has been uninstalled.
View Replies !
Can't Create/write To File In C:windows
I installed the 3.51 ODBC driver on a new test machine that is re-imaged each night to a clean OS (Win XP Pro SP2). We place our developer daily builds on this machine and run some automation. In the automation process, MYSQL statements are ran. The issue I get is that sometimes it stops with this error: "Can't create/write to file 'C:WINDOWSTEMP#sql_1808_0.MYD' (Errcode: 13), #-2147217871" or it will run right away, or sometimes it takes 3 tries before it finally gets past whatever it is choking on. I do not have MYSQL installed on that machine, only the driver. I have given the "Everyone" account full permissions, but still no luck. Any suggestions? The environment variable on the machine is set to C:WindowsTemp and it appears to execute some statements before, just is stops on some.
View Replies !
Database Permissions (Unable To Write To .CSV File)
My managed server is running 4.1.21-standard. We have been able to connect and read a .csv file into the tables, but can't write or append data from tables to a .csv file for import into another application even thought all permissions have been granted. Is this because File is not in the list of permissions to be granted? Also, first user gets kicked out when second user access the MySQL Account Maintenance page. Second user does not even have to log in to cause problems. Are these MySQL issues or cPanel issues? How can I fix them?
View Replies !
Mysqldump :: Bin/mysqldump: Got Error: 1: Can't Create/write To File
When executing the following command: bin/mysqldump -u root -p -T /Users/bj/Desktop/ tfc The following error appears: bin/mysqldump: Got error: 1: Can't create/write to file '/Users/bj/Desktop/acts.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' However, it does write the 'acts.sql' file which one of the files in the tfc database. I suspect this has something to do with permissions, but even when I run this as 'unix root user' I get the same error.
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 !
Extraction Program
I am looking for a simple extraction/load program to load data daily from a Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not necessarily need to do any data-type transforms. It need to run on Windows 2000 and be able to run it as a service, or as a cron task if running under Unix.
View Replies !
MYSQL In A Program
How would I access a database from a program? All I need to connect in the program is the IP address or the URL, though I do not know how to get those from a database. Also, I'm still having trouble with this: http://forums.mysql.com/read.php?10,141978,141978#msg-141978
View Replies !
Mysqlimport Program
I have been using load data in file command until recently on a windows machine - works fine. we are now using a Netware 6.5 box and are trying to use mysqlimport from the command line. I am using: mysqlimport --password=123456789 --fields-optionally-enclosed-by="" --fields-terminated-by="," 0608c sys:mysqlinstirling.txt to import a CSV text file into the database 0608c. the data looks like this "2007-06-28 16:07:00",0,13.58,15.77,-13.35,-12.69,-13.36,-6.61,-3.821,...... when the program executes it seems to give the desired results except the timedate is all zeros...
View Replies !
Trigger To Run An External Program
Can I trigger an external program to run when a new record is added to the mysql table? The external program is in C and instead of scanning the table continuously for new insertions, it will be better if an external program could be triggered.
View Replies !
Can't Update A Field From VB Program
I've just setup MySQL on a Linux machine and I'm using Visual Basic in Windows to connect to it (using MySQL ODBC 3.51 driver). Everything works fine for browsing the database (used for stock control), but some parts of the VB program refuse to update the database. It was using an Access database (which worked ok) and I'm using the same SQL statement and table structure. Here's the SQL statement that VB runs: SELECT Stock.GJGStockCode, Stock.PartName, Stock.Discontinued, Stock.UnitsInStock, Stock.UnitsOnOrder, Stock.ReorderLevel, Stock.ReorderQty, StockSuppliers.SupplierID, .....
View Replies !
Program Refusing To DROP DB
I am getting this problem over phpmyadmin and also over a preprogrammed php script. When there are more than 30 or 40 selected DBs the programs refuse to carry out any command when I click on the drop button. They would just take as if there is no command issued at all..... Anyone know how to make it delete more DBs at one time? I looked at trhe my.cnf file but don't see any options to do this... It however runs on small batches but I need it to drop a lot more databases at one time.
View Replies !
Database Last Accessed By A Program?
Is there an easy way to tell when my MYSQL database was last accessed by a program or even better, which programs are using them? I have 9 MYSQL databases, but I don't know which ones are connected to which programs. I suspect that I know longer use some of them, but I only want to delete the ones that aren't in use. I have MYSQL Databases, MySQL DB Wizard, phpmyadmin, and remote mysql on my cpanel.
View Replies !
Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with this command: linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and try again, then I got the messages like /tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress' My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries are installed at /usr/lib/mysql, and include files are at /usr/include/mysql. Can anybody tell me how I can configure my system to make it work?
View Replies !
Displaying TEXT Datatype With C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
View Replies !
Multithreded Program Getting Sagmentation Fault
In gdb back trace i am getting ----------------- #0 0x42073fe0 in _int_free () from /lib/i686/libc.so.6 #1 0x42074a2c in free () from /lib/i686/libc.so.6 #2 0x080efd02 in emb_advanced_command () #3 0x080f0224 in emb_stmt_execute () #4 0x080ead4c in mysql_stmt_execute () #5 0x080e592b in hlpd_Insert(st_mysql*) (MysqlConn=0x84946e0) at hlpd_insert.cpp:147 #6 0x080e534d in main (argc=1, argv=0xbffffa34) at hlpd_benchmark_main.cpp:136 #7 0x420158d4 in __libc_start_main () from /lib/i686/libc.so.6 The same Mysql database connection is used in both the threads.
View Replies !
Packaging A MySQL Database With A Program
In writing a visaul basic database program with Access as the database you simply copy the database file into the packager and it is installed with your program on the target machine. I am guessing that with mysql, since it is a 'server' program, it is not that easy. Am I wrong? And where would I find information on this. I have been working on a business accounting program and am a long way from finished, but I wanted something more robust than access as the database. I just need to know how to get the database to the target machine with my program.
View Replies !
How To Access MYSql From External Program
I have a Mysql database on a webserver and would like to access order information automatically from my home computer. I have the ecommerce software send me an email of the order and I wrote a VB program to extract the information from the email and populate an Access database. There must be a better way. Can I somehow have MS Access backup that database on my home computer?
View Replies !
Root Password :: Program Too Big To Fit In Memory
All day i'm trying to reset the root password, our webserver was crashed this week, our control panel software created a random password. I tried both methods for resetting the password, with the init tekst file and with the command -u root --skip-grant-tables. Everytime I get the same error within the command promt "Program too big to fit in memory" I tried this on two windows xp machines and one one windows 2003 server.
View Replies !
PROGRAM TO UPDATE DATA TABLES
I need to be able to DELETE selected record & LOAD DATA from a text file or Foxpro table, from a program that can run continuously. I've tried Foxpro, but FoxPro views are too slow. I have also tried issuing these command from Foxpro with an ODBC connection established, but that does not work at all. The object is to remove all records for a member and replace these records with records from a new file. Each transaction will be up to 50,000 records. I need to execute 2 commands: DELETE FROM parts WHERE parts.member_id="xxx" and LOAD DATA INFILE 'd:/xxx.txt' INTO TABLE parts
View Replies !
Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through. I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file. When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets." I have no idea what a dynaset is or why it is an error??? Is there a way around this? I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.
View Replies !
MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so: I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns. After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit. Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.
View Replies !
Program To Optimise Mysql Queries
Basically im looking for a program that will take input (my query) and produce an output with a much nicer, more efficient query. I have seen sql programs that do this sort of thing, but nothing for mysql. Just wonder if there is any programs that i have missed? Tryed Toad for mysql, but that wasnt what i wanted, i dont want a program to admin a mysql database, simply to produce a more efficient query.
View Replies !
Embedded MySQL Server Within My Clients Program
I've installed the last stable MySQL version (4.0.14-standard) under Linux, (Suse-8.0) kernel 2.4.28-64GB SMP, form the binary distribution that i downloaded from www.mysql.com. I'm interested on implementing the embedded server within my clients programs but the distribution do not have included the libmysqld.a library. There is a possible solution to this without having to get the source and compile it.
View Replies !
Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
View Replies !
Create My Own VB Backup Program For A Remote MySQL DB
I understand that the basic principles to create a TCP/IP backup program for a remote MySQL DB are: a) Query/retrieve the schema. b) Query/retrieve each table and create inserts for each row of data. The way I want to do it is even more basic, as I know what my schema is so I only need to reterieve and create the insert rows to put into my backup text file, which is basically a large DDL. The problems that I am experiencing are I want to keep the schema in an external text file so that I'm not storing it in the actual app and I thought I would also have another external file to store each 'select * from tablex' query. Is this a good way of doing it? How would I merge the results together to make a new (and 3rd) external text file backup?
View Replies !
Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
View Replies !
Gcc Compiler Error While Compiling MySQL Server.c Program
I had installed Ubuntu hardy Heron 8.04 on my laptop using Wubi to compile some server.c and client.c projects for my socket programming project on Linux OS.I was able to view the desired results with the following commands.It's only that when I re-installed Ubuntu and MySQL client-server,I'm getting the following gcc compiler errors ....
View Replies !
Insert From Python Program Create Only NULL Vals
I have a small Python program to insert data into my MySql tables. The program inserts records into the table but when I check the table it shows the correct number of records but only NULL values in the fields. I have tried it on Linux as well as on Windows version of MySQL but the same result. Any idea why this would happen?
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 !
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
