|12-20-2010, 03:47 PM||#1|
Join Date: May 2006
Making a MySQL database backup with MySQL Workbench
Making a backup in MySQL workbench is a pretty easy task, but it can be hard to find exactly where to do it the first time around. Typically when you're working in MySQL Workbench you will be using the SQL Development section. But in order to export a backup you have to move to the Server Administration section.
The first time through you will have to Create A New Server Instance. If you have already set up the connection parameters in the SQL Development section, you can just choose Take Parameters from Existing Database Connection.
MySQL Workbench will then test the connection.
In the "Remote Management Type" dialog, select Do not use remote management.
Create Instance Profile is just asking you for a name for the connection. You can enter whatever you'd like here.
When you make the connection in the Server Administration section you will see a notice that remote administration is disabled. But don't worry, you can still make a backup of your database.
When the export is complete the backup will be on your local machine in .sql format.
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|SQL Database Backup Application (Command Line) UPDATED||krmzbbr||DiscountASP.NET API||1||03-17-2009 11:16 AM|
|Create DB from a backup||MUVEKA||Databases||1||02-25-2007 10:02 AM|
|Creating new web site on DAP||wisemx||ASP.NET 2.0||2||02-25-2007 07:39 AM|
|Free On-Demand SQL Backup, Restore, and Shrink Database Tool Suite Officially Launched||Eric||DiscountASP.NET Announcements/News||0||08-01-2006 11:54 AM|
|MySQL Database Backup?||capm||Databases||0||03-19-2004 12:13 PM|