Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old August 16th, 2008, 05:53 PM
samikhan83's Avatar
Newbie
 
Join Date: Sep 2007
Posts: 31
Default How to schedule MySQL backups?

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....

Last edited by Atli; August 17th, 2008 at 06:57 AM. Reason: How to schedule MySQL backups?
Reply
  #2  
Old August 17th, 2008, 07:05 AM
Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Age: 22
Posts: 2,777
Default

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.
Reply
  #3  
Old August 17th, 2008, 04:18 PM
samikhan83's Avatar
Newbie
 
Join Date: Sep 2007
Posts: 31
Default

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
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles