How to schedule MySQL backups?

[samikhan83]

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]

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]

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