Thanks for the replies, Ryan and Paul.
I tried the suggestion of using the command prompt, and it did attempt to run the .sql file. That's when it *really* gets troublesome:
C:\mysql\bin> mysql < \mysql\cm_central.sql ERROR 1049 at line 7: Unknown database '`cm_central`'
Line 7 is: USE `cm_central`;
And yet, the database is there:
mysql> show databases; +----------------+ | Database | +----------------+ | cm_central | | dev_central | | dev_hotel_data | | isl_central | | mysql | | test | +----------------+ 6 rows in set (0.00 sec)
Any ideas why MySQL doesn't like me today?
Try omitting the backticks from the database name.
mysql has a slightly different parser than the server and that may be causing you a problem with the USE statement.
-- Paul DuBois http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- 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