mysql restore file.sql syntax error using command line

Question

when I input

mysql -u root -p XXXX dbname < c:/filename.sql

alway get this error "error 1064 <42000>:" you have an error in your SQL suntax; check the manual that corresponds to your MySql server version for the right syntax to use near .....

what is wrong with this statement?

there's nothing wrong with the statement, its the filename.sql, most probably something to do with your query check out the error — Puaka
– Puaka, Commented Apr 26, 2010 at 10:06
when i put mysqldump -u username -ppassword database_name > dump.sql; I get same error 1064 <42000>:... — Jason
– Jason, Commented Apr 26, 2010 at 11:08

mifodiy · Accepted Answer · 2012-08-09 16:10:51Z

1

I resolved it using PowerShell:

Get-Content "c:/filename.sql" | .\mysql.exe -uroot -pXXXX dbname

answered Aug 9, 2012 at 16:10

mifodiy

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

leonm · Accepted Answer · 2010-04-26 11:50:20Z

0

It is due to a reserved word in MySQL, typically because of a version mismatch.

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

answered Apr 26, 2010 at 11:50

leonm

6,47432 silver badges38 bronze badges

Comments

Jason · Accepted Answer · 2010-04-26 12:25:25Z

0

right one is C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u root -p mysql>backup_database.sql Enter password: ********

my path not right. Should not log into mysql and then execute that statement

answered Apr 26, 2010 at 12:25

Jason

3631 gold badge9 silver badges19 bronze badges

Collectives™ on Stack Overflow

mysql restore file.sql syntax error using command line

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related