How do I restore a dump file from mysqldump

Question

I was given a MySQL database file that I need to restore as a database on my Windows Server machine.

I tried using MySQL Administrator, but I got the following error:

The selected file was generated by mysqldump and cannot be restored by this application.

How do I get this working?

Answer 1

Hello @kartik,

It should be as simple as running this:

mysql -u <user> -p < db_backup.dump

If the dump is of a single database you may have to add a line at the top of the file:

USE <database-name-here>;

If it was a dump of many databases, the use statements are already in there.

Hope it helps!!

Thank you!

Comments

Does the .sql file contain the CREATE TABLE entries i.e. is it just the CREATE DATABASE entries that are missing?

---

Hello @Ankit

Yes, it does. Only 2 command are exists CREATE TABLE and INSERT INTO table.