Restore from Backup with MySQL Admin

[Jon Viney]

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.