January 20, 2011 by
When bringing up a new MySQL slave, I did the ol' mysqldump route for a change. The command usually goes something like this:
master-host $ mysqldump -uroot -p --quick --compact --all-databases | gzip | \ ssh -cblowfish slave-host "gunzip > dump.sql" slave-host $ mysql > dump.sql
I'm by no means the first person to run into this, I'm just tossing it out there as well. See http://mmatemate.blogspot.com/2011/01/about-innodb-index-size-limitations.html for a similar adventure.