Custom Search

Tuesday, March 5, 2013

How To Backup and restore MySQL databases using MySQL Workbench

How To Backup and restore MySQL databases using MySQL Workbench

A)
How To Backup MySQL databases using MySQL Workbench
----------------------------------------------------

1) Open MySQL Workbench

2) Create "New Server Instance"
* Click on "New Server Instance"

3) Open Backup/Restore window
* Click on "Manage Import/Export"

4) Click on "Data Export"
* Select Database or tables.
* Select one export option.
* Click on "Start Export" Button.

B)
How To Restore MySQL databases using MySQL Workbench
----------------------------------------------------

1) Open MySQL Workbench

2) Open Backup/Restore window
* Click on "Manage Import/Export"

3) Click on "Data Import/Restore"
* Select one import option.
* Click on "Start Import" Button.

No comments:

Post a Comment