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"
[mysqldump]
quick
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)