Difference between revisions of "mysqldump/remote"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(Created page with "To backup from a remote server, piping the file directly to your local machine (so it doesn't fill up the remote disk): ssh {{arg|user}}@{{arg|remote_host}} "mysqldump -u {{a...")
 
m (Woozle moved page MySQL/porting/data/mysqldump/remote to mysqldump/remote without leaving a redirect: reorganizing)
 
(No difference)

Latest revision as of 16:22, 4 November 2024

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