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?
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!