I want to import my local drupal site in another machine. This is what I ran from DOS from drupal root folder to get my site archive

drush archive-dump --destination=mysite.com.tar.gz

After few seconds it just stop after this message

Database dump failed.

I see the mysite.com.tar.gz file is created with my webroot fils. I don't think it created any db dump file which sounds obvious because of that error message.

These are mysql.ini settings (note the modified settings commented inline)

key_buffer = 16M
max_allowed_packet = 2M -- THIS WAS 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
max_allowed_packet = 32M -- THIS WAS 16M

What do I need to do create archive without this error? I am open for other alternatives too (other than manually ftp and dumping db file)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.