Migrating databases quickly in MySQL can be a pain when there's views involved, especially when you're copying data from one server to another, and additionally each server has it's own database users and therefore definers of views.
In Pimcore's case, theres a view for every object class created and therfore if you've done a quick mysqldump of the database you'll most likely have 'DEFINER' issues when you come to import the tables again. These definers look a little bit like the following:
To get round this, I run the following line in the console, replacing the DEFINER with the CURRENT USER.
thanks to the original src: http://xplus3.net/2013/10/10/remove-definer-clause-mysqldump/ - I've put this page up here as an archive to this very useful snippet.