MySQL 3.23.54, Win2k Server:
I am trying to take a .sql file that I got from a mysqldump from one
mysql server, and use it to populate a new mysql server, as though I
were restoring a backup after a total system crash.
I am using the following command, following the only example I could
find in the documentation ("mysql>" prompt shown for clarity):
mysql> mysql < u:/db backup 20030318/cm_central.sql;
But I get the following error message:
ERROR 1064: You have an error in your SQL syntax near 'mysql < u:/db
backup 2003
0318/cm_central.sql' at line 1
I'm going to try things like copying the file locally and taking the
spaces out of the folder name, but also just wanted to ask if I'm even
on the right track here. Is this the correct way to import from a .sql
file?
Thanks,
Tab
---------------------------------------------------------------------
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
