MySQL Forums
Forum List  »  Backup

Restore fail :
Posted by: Malcolm Sparrow
Date: April 19, 2005 02:28PM

I am having problems restoring from backup .sql files.

It's small (.sql is 128mb) and works fine, and the backup operation completes successfully.

I wish to restore the .sql to a new schema (to clone the original schema) - and over a remote SQL Admin session, it gets to random points in the restore, and then stops prematurely, telling me the operation completed successfully - and no schema has been created.

Using SQL Admin on the server itself, the restore analysis stage runs through - sometimes it aborts randomly as described above.
Other times it completes and as soon as it begins the restore proper, it stops at 971 bytes processed, with the following error message :

MySQL Error Nr. 0-

Any ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore fail :
4044
April 19, 2005 02:28PM
2636
April 21, 2005 08:51AM
2675
April 23, 2005 06:25AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.