MySQL Forums :: Backup :: Backup MySQL Server 5.1.45


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
Backup MySQL Server 5.1.45 3944 Anandhan S 09/09/2010 09:11AM
Re: Backup MySQL Server 5.1.45 1508 Rick James 09/12/2010 12:49PM
Re: Backup MySQL Server 5.1.45 1273 Anandhan S 09/18/2010 07:48AM
Re: Backup without much disk space 1631 Rick James 09/19/2010 08:56AM
Re: Backup without much disk space 1325 Anandhan S 09/19/2010 09:01AM
Re: Backup MySQL Server 5.1.45 2003 Jack Brassard 09/17/2010 04:14PM
Re: Backup MySQL Server 5.1.45 1133 Anandhan S 09/18/2010 07:42AM
Re: Backup MySQL Server 5.1.45 3301 Anandhan S 09/19/2010 09:04AM
Re: Backup MySQL Server 5.1.45 1316 Rick James 09/19/2010 10:07PM
Re: Backup MySQL Server 5.1.45 1310 Anandhan S 09/20/2010 05:18AM
Re: Backup MySQL Server 5.1.45 1237 Rick James 09/20/2010 10:51AM
Re: Backup MySQL Server 5.1.45 1291 Anandhan S 09/20/2010 09:01PM
Re: Backup MySQL Server 5.1.45 1368 Rick James 09/21/2010 12:03AM
Re: Backup MySQL Server 5.1.45 1371 Anandhan S 09/21/2010 04:43AM
Re: Backup MySQL Server 5.1.45 1296 Rick James 09/21/2010 03:48PM


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.