|
Daily database backups -
10-27-2006, 09:00 AM
Greetings Steve!
Nice job. Thank you! I see it didn't take you long to post this little "HOWTO".
Now getting a good and/or daily back up shouldn't take very long either, eh?
The real importance of this is protecting the MySQL databases which may be changing daily or even more frequently. That's precisely *WHY* that function is there. If you can't live without your data, than you better darn well protect it with current, even multiple, backups.
Also, consider the case where you can also upload local backups (say from your own personal PC) to a distant and/or distributed server(s) as a precaution against a local hard drive and/or other equipment failure, or any other disaster that you can imagine. It's just *ONE MORE* level or layer of protection, security, and redundancy.
What *IF* your office burns down and destroys your personal PC and perhaps any backups that you had?? Simply buy another PC, set it up in any other location of your choice, reconnect to the network, and download your most recent data backups from your standby site(s).
Having a "hot" alternative back up site providing protection for both your primary website(s) and your local equipment helps justify the expense of maintaining a separate, parallel site. And, as a necessary business expense, it's fully tax deductible and a form of really cheap business insurance.
The correct thinking or planning is to avoid any single point of failure by spreading out the risk over multiple machines and/or networks. That's precisely *WHY* hosting companies utilize multiple data centers.
Experiment, enjoy! Take care.
Cheers!
|