Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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):

max_allowed_packet=100M

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?

share|improve this question
    
just to make sure, what is the result of SELECT @@max_allowed_packet; when you run it on phpMyAdmin ? –  altmannmarcelo Apr 21 '13 at 21:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.