Link to home
Start Free TrialLog in
Avatar of D F
D FFlag for United States of America

asked on

Using MySQL workbench, how do you backup/restore the all your database's info?

Im using MySQL 5.5 and workbench 5.2 I would like to backup all my databases and all the complete data from my server then restore it on my local server. What is the best way to do this?
ASKER CERTIFIED SOLUTION
Avatar of wadehults
wadehults
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of D F

ASKER

Do I have to do each Database Schema one-byone?
If you are retaining the structure of all databases as an exact mirror, you can simply select all of the database schemas and compact them into a single file. The only reason you should need to do individual schema exports would be in a situation where you have different domains served from different servers.

The self-contained sql file will contain all of the databases selected, all tables, and all records. This includes all views and queries that are contained within the database schema, unless you select the option to exclude data and only keep the structure.