If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Auto DB backup

Kappar · 2002-09-01 16:06:49

Hello, I would like to automate a backup of a MySQL DB on my website about once a day. I would like to copy the data to another server. I have heard about 'Cron Jobs' could this be used to do that if so can anyone recommend a site with a tutorial on Cron Jobs or can anyone give a quick example on how it could be done. Is…

Options

01-09-2002 5:06pm

#1

Kappar

Closed Accounts Posts: 1,114 ✭✭✭

Join Date: November 2001

Posts: 877

Hello, I would like to automate a backup of a MySQL DB on my website about once a day. I would like to copy the data to another server.

I have heard about 'Cron Jobs' could this be used to do that if so can anyone recommend a site with a tutorial on Cron Jobs or can anyone give a quick example on how it could be done.

Is there any other way it could be done?

0

Comments

Options
#2 01-09-2002 9:16pm
steve-hosting36

Closed Accounts Posts: 2,161 ✭✭✭

Join Date: January 2002

Posts: 2097

Hi Kappar,

Option a:
Grab something like http://worldcommunity.com/opensource/utilities/mysql_backup.html

Option b:
Write a simple shell script along the lines of

mysqldump -uUsername -p dbname > dbname.sql
ftp ftp.yourremoteserver.com -uUsername -p
put dbname.sql
exit

And run it daily. (see something like http://www.faqts.com/knowledge_base/view.phtml/aid/1005/fid/436 for more on how cron and crontab work)

HTH,
Steve

0