mysql, dump, database restore

Question

I have dumped my database with the following command:

mysqldump -uuser -ppassword db_name > file 

then I completely removed my database:

drop database db_name; 

then I created a new database:

create database db_name; 

and then I tried to restore the db with the following command:

mysqldump -uuser -ppassword db_name < file 

The problem is that dump does not create tables and loads data in them and so the database remains empty however it does show a message like dump completed "date time"

What could be the reason for this?

Answer 1

mysqldump is for dumping the database. You've created a new empty database, and then dumped that empty database. Use mysql instead to reload your dump

mysqldump db > dump.sql mysql drop/create mysql db < dump.sql 

would be the basic command sequence.