mysqldump/remote
< mysqldump
Jump to navigation
Jump to search
Revision as of 16:22, 4 November 2024 by Woozle (talk | contribs) (Woozle moved page MySQL/porting/data/mysqldump/remote to mysqldump/remote without leaving a redirect: reorganizing)
To backup from a remote server, piping the file directly to your local machine (so it doesn't fill up the remote disk):
ssh <user>@<remote_host> "mysqldump -u <username> -p <database_name> | gzip -c" > <local_filename>.sql.gz