MySQL Forums
Forum List  »  MySQL Administrator

about backup and restore
Posted by: yongzhen fu
Date: September 07, 2005 02:56AM

when i backup a database(these are some tables),i select the No CREATE option ,then it prompt success.

After, i delete the database i just backup.
When i restore it ,it prompt success.there is a surprising phenomenon : when i want to view the database that i want,but i find nothing.

After,i create another database that is null.i try to restore data to this database.also it prompt success,but when i view the database,these isn't any tables.

i use the mysql administrator version 1.1.1 rc and MySQL server 5.0.9 beta.

i watch the mysql administrator ,it said:
No CREATEs will supress CREATE DATABASE statements. This can be useful if you need to restore the data to a different database than it was backed up from.

i don't kown why.



Edited 1 time(s). Last edit at 09/07/2005 02:58AM by yongzhen fu.

Options: ReplyQuote


Subject
Written By
Posted
about backup and restore
September 07, 2005 02:56AM
September 07, 2005 04:35AM
September 07, 2005 08:44PM


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.