RE: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
At 14:56 -0500 3/19/03, Tab Alleman wrote: Paul DuBois wrote: Line 7 is: USE `cm_central`; 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. Thanks again Paul, that did the tr

RE: Restoring from a .sql file

2003-03-19 Thread Tab Alleman
Paul DuBois wrote: >> Line 7 is: >> USE `cm_central`; > 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. Thanks again Paul, that did the trick...which is kind of a BitterSw

RE: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
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 databa

RE: Restoring from a .sql file

2003-03-19 Thread Tab Alleman
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_cent

Re: Restoring from a .sql file

2003-03-19 Thread Paul DuBois
At 12:31 -0500 3/19/03, Tab Alleman wrote: 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, fo

Re: Restoring from a .sql file

2003-03-19 Thread Ryan Fox
On Wednesday 19 March 2003 12:31 pm, Tab Alleman wrote: > 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; Run this from a command line, not the mysql clien

Restoring from a .sql file

2003-03-19 Thread Tab Alleman
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 t