Custom Search
Showing posts with label WorkBench. Show all posts
Showing posts with label WorkBench. Show all posts

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.

Sunday, March 3, 2013

How to create ER Diagram from existing Database using MySQL WorkBench

How to create ER Diagram from existing Database using MySQL WorkBench