How to copy the whole database to another server database?

mysql mysql-workbench
Vinoth picture Vinoth · Sep 18, 2012 · Viewed 41.3k times · Source

I am currently working on a Windows application with a MySQL backend. Now I want to copy the old database structure and data to a new database server.

How can I solve this problem using MySQL workbench?

Thank you!

Answer

Alberto León picture Alberto León · Sep 18, 2012
  1. Open MySQL Workbench
  2. Create the old server's connection (if you haven't it)
  3. Create the new server's connection (if you haven't it)
  4. Go to Server Administration and click Manage Import / Export
  5. Select old server
  6. Select all schemas in Export to Disk tab
  7. In options select Export to Self-Contained File, wait until it finished
  8. Back to Server Administration and click Manage Import / Export
  9. Select new server
  10. Switch to "Import from Disk"
  11. Click "import from Self-contained File

This is the way with only MySQL Workbech, some times you haven't it installed in new server, like in development to production scenario, in this way you should execute the mysqlimport utility.

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More