Drupal migration / database clone / import issues - problems

iKnow-IT banner

If you migrate a Drupal environment from one system to another system and you discover problems during the import of the sql database and you get a message like:

insert ... failure ... cache_...

This is easily solved to clear the cache on the system that need to be cloned before you make a backup

put the site in Maintenance 
goto "Configuration" => "Maintenance mode" and click on the check box "Put site into maintenance mode" and click on "Save configuration"

than clear the cache
goto "Configuration" => "Performance" and than click on the Button "Clear all caches"

Now you make a backup with e.g. phpMyAdmin

after the backup is made remove the maintenance from the site
goto "Configuration" => "Maintenance mode" and uncheck the check box "Put site into maintenance mode" and click on "Save configuration"

now try to import the just made backup on the other system.