mysqldump doesn't create tables or import any data

Solution 1:

You want to run the dump through the mysql client.

Example:

mysql -uroot -p testimport < database.dump

Solution 2:

Because when you dump data (Backup) you used "mysqldump" :

mysqldump -u user -p Database_name > SQL_dump_file.sql

But when restore data into database you need to use only "mysql":

mysql -u user -p Database_name < SQL_dump_file.sql