Doctor Feelgood
Administrator
|
 Posted: Mon, 11 Apr 2005 15:26:26 Post Subject: |
 |
|
| IceNine wrote: | | My recommendation is to use the mysqldump utility to pipe the data into a file, then gzip it for archival. Plus, what method creates all the backups? |
Yes, that is what I do, and plan to keep doing. I have CRONs setup to run that nightly.
Presently... the first CRON does a mysqldump from drive a to b everyday at 2AM. The next CRON is based on the day of the week, so I can maintain 7 recent backups... So, at 3AM this CRON gzips the mysqldump file into an archive with the day of the week in the filename. Therefore, there are 8 files in the sql bacup folder at any given time.
OK, I will put the mySQL on drive b now, and symlink it back into /var/lib on drive a.
I will then create my backups of /home and mySQL to sda.
Right?
Now... what about finding the rest of the disk space I think I should have?!? |
|
