mysqldump/remote

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< mysqldump
Revision as of 19:08, 11 August 2024 by Woozle (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "https://htyp.org/mw/index.php?title=mysqldump/remote&oldid=28921"