Home > MySQL > Backup And Restore MySql Database Using MySql Administrator

Backup And Restore MySql Database Using MySql Administrator


Here in this article we will learn how to take backup and restore database in mysql using MySql Administrator Utility.

Steps:

1) Open  MySql Administrator

2) Select Backup in the Left hand side menu

3) Click on “New Project” Button shown at the bottom in the right hand side

4) select your database from the list shown and click “>” arrow button

5) Click on “Execute Backup Now

and save as file dialog will open and save the file accordingly.

To Restore the database, follow the following steps

1) Open MySql Administrator

2) Click on “Restore

3) Click on “Open Backup File

4) Browse file and specify Target Schema click on new schema or specify existing database

5) Click on “Start Restore

Another way of Restoring Db is, follow the below steps:

1) Open MySql Query Browser

2) Click on File menu -> open script – > browse to the backup file

3) Click on Execute

About these ads
  1. hiteshagja
    May 11, 2010 at 1:03 pm

    Dear Sir,

    Sometimes I have seen that backup script includes lots of blank lines. And script will become big in size and sometimes fail to restore. Do you have any solution for that ?

  2. pankajlalwani
    May 12, 2010 at 5:50 am

    Yes sir,

    i encountered the similar problem of blank lines, which can be eliminated by blank line s/w..i dont remember the name exactly will let u know.. till then u can try this alternative : http://bit.ly/5RCcre

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: