MySQL Forums :: Backup :: Backup MySQL Server 5.1.45
Re: Backup without much disk space
Posted by: Rick James ()
Date: September 19, 2010 08:56AM
If you are doing a mysqldump and don't have enough disk space for the output, what are the alternatives?
* If you have some space, but not enough, compress on the fly:
mysqldump ... | gzip >dump.gz
(This may not work well on Windows.)
* Pull the output from another machine:
host2$ mysqldump -h host1 ... >dump.sql
This may require granting access explicitly for host2.
* If you have some space, but not enough, compress on the fly:
mysqldump ... | gzip >dump.gz
(This may not work well on Windows.)
* Pull the output from another machine:
host2$ mysqldump -h host1 ... >dump.sql
This may require granting access explicitly for host2.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates