I am developing a site (locally) and want to keep what I've done so far, but also try a very different configuration of modules. I wanted to duplicate my site so I can develop an alternate version. My understanding of how to do this is:
Duplicate/rename the base file directory
Create a new database
Export the old database files
Import the old database files into the new database
Change the settings.php file in the new database
When I try to import the old database into the new, I get the following error in phpMyAdmin:
Error
SQL Query:
Dumping data for table 'cache_menu'
Insert into 'cache menu'
Values (really long list of letter and numbers)
SQL said:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
Anyone understand the error message? I'm a designer with only a cursory understanding of phpMyAdmin and databases, so it's entirely possible I'm going about this in some boneheaded fashion. Is my list of steps appropriate for what I'm trying to do?
Comments
try emptying the cache
It sounds like you're doing everything right. A couple of things to try, in order of difficulty:
Try going to admin/settings/performance (in Drupal 6), and clicking the "empty cache" button. Then re-export the database.
If that doesn't work, you can just empty that table -- Drupal will regenerate it. Run this command from inside MySQL:
truncate cache_menuAlternately, you can adjust your MySQL configuration to handle bigger packets. In my.cnf, add a line like this (you may need to try different values):
max_allowed_packet=64Mtruncate cache_menu did the trick
#2 was the charm. Thanks!
Using backup & migrate rather than phpmyadmin export
Also, it appears that using the backup & migrate module will automatically empty the cache_menu and some of the other tables before exporting the database. So using that rather than the export function in phpMyAdmin may have saved myself a headache.