MySQL Forums
Forum List  »  Newbie

Restore from Backup with MySQL Admin
Posted by: Jon Viney
Date: October 05, 2007 03:14AM


I am trying to restore a mysqldump txt file to another cpu using MySQL Admin. I receive an error:
The selected file was generated by mysqldump and cannot be restored by this application.

I understand there are other ways of transfering a database to MySQL on a different cpu.
ie. mysql -u Username -p DBname < Filename.sql

When I try this it doesn't work I'm doing something wrong. Does the "filename" need to be an exact path to the file or just the file name ie. C:\folder\folder\database.sql

Also does it matter if the file is .txt or .sql?
Does it matter where I have the database.sql file on my computer?
Do I need to have a new empty database created?

I'm really confused! just after an easy way of transfering my database between computers

Thanks for your help

Edited 1 time(s). Last edit at 10/05/2007 03:18AM by Jon Viney.

Options: ReplyQuote

Written By
Restore from Backup with MySQL Admin
October 05, 2007 03:14AM

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.