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> 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
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.