Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Attempting to import data to Mysql using mysqlimport
Running MySql version 5.6.17 on a ML350 G5 server. The operating system is Small Business Server 2008
Please understand I am learning Mysql . I am not an expert.
I am trying to import a text file using mysqlimport utility.
The command is below:
mysqlimport --user=root –password=dbxxx --fields-terminated-by=”,”
The problem:
When I put the above command into a batch file mysql displays the error:
“Error 1045 Access denied for user 'root @ localhost' (using password NO)
So I created a batch file which would change directory to the path where mysql exists . The path is:
c:\program files\Mysql\Mysql server 5.6\bin
Then I manually typed the mysqlimport command above and the data successfully imported
Questions:
Q1.) I have attached the batch file and the txt file and the table structure. What changes would you make to this batch file so I don't have to manually type the mysqlimport command?
Q2.) What must I do so the password does not have to be entered as part of the mysqlimport command?
Please give detailed answers. I am not a mysql expert.
Useful links are always appreciated.
Thank you for your help.
tblpivottxt.txt
Mysql-Import.txt
tblpivottxt-structure.png
Please understand I am learning Mysql . I am not an expert.
I am trying to import a text file using mysqlimport utility.
The command is below:
mysqlimport --user=root –password=dbxxx --fields-terminated-by=”,”
The problem:
When I put the above command into a batch file mysql displays the error:
“Error 1045 Access denied for user 'root @ localhost' (using password NO)
So I created a batch file which would change directory to the path where mysql exists . The path is:
c:\program files\Mysql\Mysql server 5.6\bin
Then I manually typed the mysqlimport command above and the data successfully imported
Questions:
Q1.) I have attached the batch file and the txt file and the table structure. What changes would you make to this batch file so I don't have to manually type the mysqlimport command?
Q2.) What must I do so the password does not have to be entered as part of the mysqlimport command?
Please give detailed answers. I am not a mysql expert.
Useful links are always appreciated.
Thank you for your help.
tblpivottxt.txt
Mysql-Import.txt
tblpivottxt-structure.png
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
To use that command format, you must have two '--' in front of password, not just one. A single '-' is for a different format.
mysqlimport --user=root --password=dbxxx --fields-terminated-by=”,”
http://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
mysqlimport --user=root --password=dbxxx --fields-terminated-by=”,”
http://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
Hello Uma Surya: I run the batch file in a command prompt. When I invoke the command prompt, I explicitly invoke Administrator privileges so I feel there is no Windows permission problem.
Hello Dave Baldwin:
Thank you for your help. It always pays to have 2 sets of eyes to solve a problem. You are correct, I needed 2 dashes in front of the password command. I retyped the batch file, some how there were strange characters in the batch file itself. Now it works.
So how about question 2, : How do I eliminate the need to have the password in the batch file?
Hello Dave Baldwin:
Thank you for your help. It always pays to have 2 sets of eyes to solve a problem. You are correct, I needed 2 dashes in front of the password command. I retyped the batch file, some how there were strange characters in the batch file itself. Now it works.
So how about question 2, : How do I eliminate the need to have the password in the batch file?
Premium Content
You need an Expert Office subscription to comment.Start Free Trial