can you dump the database to a remote server?

[captnroger]

Help!!!

I need to dump the contents of a database here, but don't have enough local space to do it.[nbsp][nbsp]Is there a mysql command that will let me dump it to a remote server via FTP?

[jbroder]

I don't think futurequest minds if you go over your quota for a few minutes. Just dump, compress, download, delete.

[Terra]

Do an 'inline' compressed dump...

Adjust the following to your needs:
$mysqldump .........[nbsp][nbsp]| gzip -9c >database_dump.gz

If you have a database elsewhere:
$mysqldump ......... | mysql -u -p -hotherhost.com database

Via SSH to another site:
$mysqldump ......... | ssh otherhost.com 'gzip -9c > ~/database_dump.gz'

There are lots of other creative pipe tricks which could possibly cure world hunger...

--
Terra
sysAdmin
FutureQuest