I'm running the following command:
mysqlimport --lines-terminated-by="\r\n" --fields-terminated-by="," --fields-enclosed-by="" --replace -u root -ppassword clocking_development sales_orders.txt
...
http://www.experts-exchange.com/Database/MySQL/Q_22516041.html
Zones:
MySQL ServerDate Answered: 04/17/2007 Rating: 9.2 Views: 0
Hi,
I am trying to move some data from an excel spreadsheet into a mysql table I created.
I am doing this by first exporting from excel a tab delimited txt file and then calling mysqlimport wit...
http://www.experts-exchange.com/Database/MySQL/Q_21492032.html
Zones:
MySQL ServerDate Answered: 07/15/2005 Rating: 9.6 Views: 19
Hi,
I am an Oracle use who is new to mysql and mysqlimport. I am getting some Warnings after the data is imported. Glancing the data does not tell me where the warnings come from. What is the s...
http://www.experts-exchange.com/Database/MySQL/Q_21495761.html
Zones:
MySQL ServerDate Answered: 07/21/2005 Rating: 8.2 Views: 9
I am trying to import a text file called 'test.txt' into a table called 'test' of a database called 'test'. This is my mysqlimport command:
mysqlimport -u [user] -p[password] -c "test1,test2" te...
http://www.experts-exchange.com/Database/MySQL/Q_21544351.html
Zones:
MySQL ServerDate Answered: 08/31/2005 Rating: 8.7 Views: 4
Hi experts,
I'm following the guide located here http://www.delau.net/php/geoip.html to import a CSV file into a db but i can't get past step 2 because i have never used the mysqlimport system b...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
How do you create files to import to mysqlimport? mysqldump create SQL of a given table/db, but mysqlimport needs some other form of data. How can I export from the mysql command-line in a format t...
http://www.experts-exchange.com/Database/MySQL/Q_22556319.html
Zones:
MySQL ServerDate Answered: 05/07/2007 Rating: 9.8 Views: 0
Hi There,
I was wondering if someone could help me with the syntax to import a .dmp file into my mysql db? I am using the version of mysql 4.0.20ant.
I use the syntax below:
mysqlimport --no-d...
http://www.experts-exchange.com/Database/MySQL/Q_21138650.html
Zones:
MySQL ServerDate Answered: 09/21/2004 Rating: 9.0 Views: 0
I am trying to copy a MySQL UNIX database on to a Win/XP machine.
I used UNIX phpAdmin MySQL-Dump Ver 2.3.1 --all-databases to dump all my tables from one database into a file titled myfile.SQL....
http://www.experts-exchange.com/Database/MySQL/Q_21302321.html
Zones:
MySQL ServerDate Answered: 01/16/2006 Rating: 8.6 Views: 0
I'm trying to do the following:
1) Go to a production computer and get a copy of hte database.
2) Go to the development and create a copy of it
What command lines would I need?
http://www.experts-exchange.com/Database/MySQL/Q_24503282.html
Zones:
MySQL ServerDate Answered: 07/23/2009 Rating: 9.6 Views: 0
MySQL uses backslash as the default escape character.
I have a tab delimited text file. Some of the fields contain a backslash as the last character of the field.
mysqlimport escapes the seq...
http://www.experts-exchange.com/Database/MySQL/Q_24812200.html
