At 14:07 -0500 3/19/03, Tab Alleman wrote:
>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
