Migrating all MySQL databases from from one server another. Getting error during import I create a mysqldump on all the databases on the source server with this command:



  mysqldump -h mysql-01 -u root -p --all-databases > newdump.sql


This takes about an hour, but runs fine.


Now, to migrate the data of the dump file on the destination server I run this:



  mysql -h mysql-vm-01 -u root -p &lt; newdump.sql 


all seems to be going fine for like 30 minutes and then I get this error


  ERROR 1449 (HY000) at line 100083 : The user specified as a definer ('dc_reporter'@'%') does not exist. 


What should I do ??
Perhaps you should dump the users and load the users into the VM

Here is my post : Export all MySQL users

After running the code in it and saving it to a file called MyDatabaseUSers.sql, you log into mysql on the VM and run this:

mysql&gt; source MyDatabaseUSers.sql


This will create all the users with the same grants and passwords. Don't worry: Passwords are encrypted.

After importing the users, you should be able to reload the mysqldump.

GIVE IT A TRY !!!

NOTE: If you loaded all your data successfully, the error might have occurred loading a MySQL object that has a DEFINER associated with it


stored procedures
triggers
views
events.


Do the following:

cat newdump.sql | grep -A 2 -n "dc_reporter"


This will show you what might not have loaded. Your data may all be there.

You could try dumping your stored procedures and triggers and reloading them instead of reloading everything. Please read my old post Can mysqldump dump triggers and procedures?, go dump your triggers and stored procedures, and reload them into the VM. If you have views to import, please read my old post Modify DEFINER on Many Views and use the code to mysqldump just the views.