MySQL Forums
Forum List  »  Backup

Problem restoring backup from mySQL Adminstrator
Posted by: Sidney Lin
Date: October 22, 2005 04:27PM

I'm having problems restore a backup of a database I made from another MySQL Server. I was using MySQL Administrator 1.4 on a MySQL 4.1.11-nt server. The backup went smoothly, but when I tried to restore, it would give me a warning/error on the line containing the word "USE"

Here's the error it gives me
Warning: Do not know how to handle this statement at line 21:
USE `product 3`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

The MySQL Server returned this Error:
MySQL Error Nr.1046-No database selected

I did do some experimentation on the .sql file generated by the backup function.. I changed the database name to not have any spaces.. which did allow me to restore everything.
so.. is there way to fix is so I don't change the database name to restore my stuff? Note that the USE command did have the `` quotes around it.. there must be a problem with the USE command and spaces.

here's some of the text in the .sql file
-- Create schema `product 3`

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `product 3`;
USE `somaport3`;

-- Table structure for table `product 3`.`-= info =-`

THanks for the help.

Options: ReplyQuote

Written By
Problem restoring backup from mySQL Adminstrator
October 22, 2005 04:27PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.