Need Help with mysqlimport please-urgent!
Hello, Here is my problem, I would like to use mysqlimport (which i have compiled as a batch file to run) from a client side to load data onto the database on a server side, meaning that I would normally access my server through the pc and running the batch file. Problem is that there are no errors but the tables on the server side does not get updated but instead points to updating my local database, data are loaded into my tables instead (i have the exact replica database on my own pc). Here is a sample command line from my batch file @h:\mysql\bin\MYSQLI~1.EXE --replace --host=host_name --user=root --fields-terminated-by=, --fields-enclosed-by=\ --lines-terminated-by =\r\n BO h:\mysql\data\BO\outnum i've mapped h:\ as pointing to the c:\ of my server..is that possible? [The error relates to 'access denied for @pc_id (i think its the same network id used for login to a NT domain) to BO database' or at times 'the mysql does not support this version'] P.S. My table name is outnum which is the same as the file name, MySQL version is 3.23.51. What am i doing wrong here? Need help please (could someone guide me what to do from the very beginning. I need to run mysqlimport as if i'm running any program from the console itself but only from a remote terminal). To simplify, what i need here is a way to run mysqlimport from my pc to pump data into the tables on the MySQL server instead of the data being thrown in my local MySQL server.Urgent! Thank you. Regards, Eric Loe. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load Data Problem
Hie there, I'm having a potential problem with Load Data Infile function where i'm unable to get the right no. of records to appear in the table. I have a table created in MySQL with 2 fields region (char 1)-pkey and regionname (char 30). The table name is called region. I've also created a text file(Test.txt) with the following contents 1,New Record 1 2,New Record 2 3,New Record 3 My SQL load statement is: Load Data Infile 'test.txt' into table region fields enclosed by '' terminated by ,; The result: Query OK, 2 rows affected Records:2 Deleted:0 Skipped:0 Warnings:1 As you can see, only the 1st and 3rd lines of records are input in, the 2nd is ignoredany explanations? By the way, i'm using mysql ver 11.16 Distrib 3.23.49 for Win95/98 (i32) Any help would be much appreciated. Thanks Regards, Eric. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQLImport utility
Hie I'm new in MySQL.anyone out there can help please? I'm actually experimenting with the mysqlimport utility to import data from a text file.however i'm always getting this error upon the command c:\mysql\binmysqlimport - - local - -fields-terminated-by=, test newtest.txt ERROR: The used command is not allowed with this MySQL version, when using table: newtest P.S. My SQL version is Ver. 11.16 Distrib 3.23.49 for Win95/98 (i32) Also i created a txt file with the following structure 100,200 200,200 300,300 . My table is newtest with 2 fields of char datatype of size 10. Please help. Thanks. Regards, Eric. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php