PDA

View Full Version : MYSQL Backup & Restore



mdueri
04-30-2004, 03:26 PM
Does West host automatically backup our databases? Daily or weekly?Can they restore them if necessary or do we do that. How is this done. I did the mysqldump command which outputted a file but how does that get restored should something happen to my MYSQL database? If anyone can point me in the right direction I would appreciated it since my business could not exist if my db is messed up.

Mark

wildjokerdesign
04-30-2004, 03:30 PM
Have you installed phpMyAdmin on your account via the Site Manager? That is how I manage most my databases.

Not sure if WH backs up the databases or not. I have always assumed it was my responsibility or at least a good idea to have a back up of things on my local computer just in case.

j103c
04-30-2004, 03:34 PM
WestHost says they perform system backups:

http://www.westhost.com/popup/pophourlybackups.html

WestHost - MMellor
04-30-2004, 04:32 PM
Hello Mdueri,

Our backups are actually done daily and it backs up your entire site. This includes your databases and everything else that is installed and stored on your site. Please let us know if there is anything else we can help with.

mdueri
04-30-2004, 04:46 PM
All helpful info - I didn't know about the export command on myPHPadmin.

Thanks
MDueri

wiltech
05-06-2004, 10:07 AM
I use a set of PHP scripts on one of my client sites for mysql database maintenance including backup and table checking. I have the script backup my database daily using mysqldump, compress the file, and email the file to my webmaster account. If you'd like to see the scripts let me know.

Kalin

mdueri
05-06-2004, 02:12 PM
That would be great if you want you can mail them to me at
markd@walkandshop.com

wildjokerdesign
05-06-2004, 02:34 PM
Sounds like a handy set of scripts. Be great if you would post them or if you like would be happy to post them on my WH help page.

wiltech
05-06-2004, 11:01 PM
Best to give credit where due... I couldn't remember where I got the scripts so took at look at the copyright. Here is where to get them:

Backup Script
http://www.phpfreaks.com/script/view/11.php
Very handy. Good instructions. I had to download and install ncftp to get ncftpput which the script uses to upload backups to a ftp server. I have the script configured both as a page that can be called from an admin menu on the site as well as a command line script that is called by cron daily. If anyone needs help with that kind of configuration let me know.

database optimizer
http://www.nirvani.net/software/optimize_database/optimize_database-1.0.0a.php.asc
Again I have the script embeded in a web page for use from an admin menu as well as command-line version. This one doesn't work as well from the web because there is no feedback and it can take a while on large databases. Good place to start from though.

database monitor
http://px.sklar.com/code.html?id=454
This is another one that would be good as a cron job. Currently I only have it set up to be called from a web page in the admin menu.

Good luck!
Kalin