Re: [tlug] Remote MySQL backup and download

[Francois Cartegnie <fcartegnie@example.com>]

Le vendredi 13 mars 2009, David Shanahan a écrit :
> If you want to use a pipe in your command, use quotes otherwise your
> local shell will setup a local pipe
> ssh user@example.com "mysqldump dname | bzip2" >`date -I`.db.dump.bz2

I'm not a fan of MysqlDumping over network (dsl?) as your dump speed is 
limited to the transfer (+compression) speed. Mysqldump needs to lock myisam 
tables and, depending on size, you might end up with blocking for many 
minutes your sql servers. So, if the tables are non transactional, it's 
better to make a local dump, compress, then transfer.
But not using another technique than mysqldump is even better :)