MySQL problems...

[pfchin]

Dear All,

I hav encounter some problems with the new installation of MySQL 4.0.2-nt, it looks fine after it was installed but when i want to put the database back from backup.sql to mysql it keeps on showing me error message, and the error message is:

mysql> mysql testdatabase < "c:\backup.sql";

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql testdatabase < "c:\backup.sql"' at line 1

in the previous version it doesn't hav this problems... can anyone help me???

thanks & regards,
pf

[jblack]

Try running this from the command line:

mysql testdatabase < c:\backup.sql

You seem to be trying to execute that inside of the mysql client itself. It was meant to be run from the command line. I've never used this before but I found it on the mysql site at:

http://www.mysql.com/doc/en/mysql.html