I'm having a nightmare trying to clone a live Wordpress site into a local dev environment using MAMP Pro and BackupBuddy.
I have no problem with setup. The problem is that there seems to be some issue within my database that prevents import.
Backupbuddy fails at the database import stage.
If I switch and try to import manually, via MAMP PRO's phpMyAdmin, I get the following:
2006 - MySQL server has gone away
The import always stops at the same place: with my wp_options table.
Experimenting, I was able to import the full database when the wp_options table was NOT included. Thereafter, trying to import only the wp_options table leads to the same error.
The wp_options take is only 3MB. The whole database is 13MB.
I followed suggestions online relating to increasing some basic configuration values. In MAMP PRO's startMysql.sh (MAMP.app/bin/startMysql.sh):
I also added the following to my php.ini (MAMP PRO.app --> File menu --> Edit Template --> PHP ..)
max_allowed_packet= 100M wait_timeout= 6000
Memory limit (in php.ini) is 256MB, max input time is 600, and max execution time is 600.
These values should be more than enough to prevent the "#2006 - MySQL server has gone away" error, but I'm still getting it.
FURTHER, I have tried importing the database as xml, and csv. So far, I simply cannot get a working copy of this database going in my localhost environment.
I even wanted to simply export and cut and paste the actual database, but then I find that Wordpress uses .frm .MYD and .MYI files, and my export is a .sql file that likely phpMyAdmin would convert and segment out, but then the import fails.
Does anyone have any suggestions?