Answers.Body: <p>The triggers have a DEFINER that needs to exist and have the right permissions so if the db user is different you might run into some problems there. If by "full" you mean you are also restoring the system mysql.user table that might be ok but that might cause other problems with the hosting provider control panel depending how they are set up.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-22T18:49:35.920Z
Answers.LastActivityDate: 2019-01-22T18:49:35.920Z
Answers.UserDisplayName: Demerit
Body: <p>I've moved Civi a few times in the past 2/3 years, following the docs esp. the PhpMyAdmin method.  Lately the restore using this method has failed even though I followed the docs - because of foreign key restraints (error 1215) - so I've emptied the target db and done a full backup &amp; restore with no problem. The last move I just made a full backup &amp; restore with no problems - this is at 5.7.3 level. So I guess that improvements have been made &amp; for systems at 5.7 level moving Civi is more straightforward than the docs say.  This is good news of course!  Perhaps it's just the docs that need updating, but I wonder what other users have found?</p>
  
Tags: <documentation>
Title: Is moving Civi easier than the docs say?
ThreadText: # Is moving Civi easier than the docs say?
  
  (Asked by: username_0 on 2019-01-22)
  
  I've moved Civi a few times in the past 2/3 years, following the docs esp. the PhpMyAdmin method. Lately the restore using this method has failed even though I followed the docs - because of foreign key restraints (error 1215) - so I've emptied the target db and done a full backup & restore with no problem. The last move I just made a full backup & restore with no problems - this is at 5.7.3 level. So I guess that improvements have been made & for systems at 5.7 level moving Civi is more straightforward than the docs say. This is good news of course! Perhaps it's just the docs that need updating, but I wonder what other users have found?
  
  **Tags:** documentation
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-01-22. Score: 1
  
  The triggers have a DEFINER that needs to exist and have the right permissions so if the db user is different you might run into some problems there. If by "full" you mean you are also restoring the system mysql.user table that might be ok but that might cause other problems with the hosting provider control panel depending how they are set up.
  
  
  ---
  
  