Re: Migrate database with mysqldump and mysqlrestore

[Rick James]

mysqlimport is the wrong tool.

Look at your file ( /tmp/testDB.sql ). You will, or won't see DROP and CREATE statements, depending on the options for mysqldump. If it does not do a CREATE DATABASE, then the first line will be needed:

$ mysql
mysql> CREATE DATABASE testDB;
mysql> source /tmp/testDB.sql
mysql> exit;