CiviCRM Community Forums (archive)

Did you follow all of the steps of the Migration guide? Such as removing template files and resetting civicrm_domain settings etc?

Problem Solved: 

For the benefit of anyone else reading this post, here is what I learned ... maybe help for someone ... maybe not, but make note.

As it turns out ignoring cache, etc in the initial dump was not the direct solution for my situation.  I had failed to disable CiviCRM and an associated module before doing a MySQLdump, AND needed to remove any occurrence of DEFINER='username'@'localhost'  statement from the dump.sql file.

As pointed out by Hershel, following the migration guide is important in the process with additionally skipping triggers when dumping to avoid MySQL choking on an insert.  I learned about this from Eileen on the IRC Forum (thanks, Eileen, where ever you are .. )  and to iterate, be sure to disable the CiviCRM module and any CiviCRM associated modules before doing a dump.  How and why for this entire process (excluding when/how to skip triggers and the DEFINER issues) is found at the article that Hershel alluded to:   http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location

Thank you, Hershel.

Carl