Connecting Tech Pros Worldwide Forums | Help | Site Map

How to schedule MySQL backups?

samikhan83's Avatar
Member
 
Join Date: Sep 2007
Posts: 33
#1: Aug 16 '08
i love mysql.....

i have my applications running on mysql database... everything works fine.....

if i execute the back up manually i am getting the full back up......
i am having the problem with schedule back up...
how i need to configure schedule back feature....i followed all the step given in mysql manual but i am not getting the schedule database back up....

i am trying this for first time..... so please guide me ......

THANX IN ADAVANCE....

Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Posts: 3,754
#2: Aug 17 '08

re: How to schedule MySQL backups?


Hi.

How exactly are you backing up your databases?
Can you show us the code / commands your are using?

MySQL provides the mysqldump command, which, when combined with your operating-system's task scheduler, should make this easy.

If you are using Linux, look into crontab.
On Windows, you would want to use the Task Scheduler.

P.S.
I have changed the title of this thread, to better describe it's contents.

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.
samikhan83's Avatar
Member
 
Join Date: Sep 2007
Posts: 33
#3: Aug 17 '08

re: How to schedule MySQL backups?


Quote:

Originally Posted by Atli

Hi.

How exactly are you backing up your databases?
Can you show us the code / commands your are using?

MySQL provides the mysqldump command, which, when combined with your operating-system's task scheduler, should make this easy.

If you are using Linux, look into crontab.
On Windows, you would want to use the Task Scheduler.

P.S.
I have changed the title of this thread, to better describe it's contents.

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.


i did not used mysqldump i am usingmysql query browser ide schedule back up feature which is in mysql administrator of query browser

i will try what you have suggested ....

thanx alti ..... YOU ARE EVERYWHERE FOR HELP
Reply