1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to take backup and restore of mysql by using batch script on windows

Discussion in 'MySQL Forums' started by haraprasad, Jul 16, 2009.

  1. haraprasad

    haraprasad Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    i am using mysqldump command to take backup and mysql command to restore it.
    For example backupscript as follows:mysqldump -uroot mydb > c:\hara\mydbbackup.sql -pmaster
    For restore:mysql -uroot mydb < c:\hara\mydbbackup.sql -pmaster
    so i want to do this thing by using windows batch script,Is this a good idea for doing automatic backup and restore of mysql or not ?
    How to do it Please suggest..
    Any suggestion will appreciate me a lot.
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    This Link may help you .