Skip navigation links

MySQL Forums :: Newbie :: Restore from Backup with MySQL Admin


Advanced Search

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

Hi,

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


Subject Written By Posted
Restore from Backup with MySQL Admin Jon Viney 10/05/2007 03:14AM
Re: Restore from Backup with MySQL Admin Jon Viney 10/05/2007 04:06AM
Re: Restore from Backup with MySQL Admin marc castrovinci 10/05/2007 06:29AM
Re: Restore from Backup with MySQL Admin Jon Viney 10/05/2007 06:48AM
Re: Restore from Backup with MySQL Admin Jon Viney 10/05/2007 07:03AM
Re: Restore from Backup with MySQL Admin Jon Viney 10/05/2007 07:18AM
Re: Restore from Backup with MySQL Admin Jon Viney 10/05/2007 07:38PM


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.