There is often a need to migrate MySQL databases - be it to transfer the data to a testing server
or to completely migrate the entire database to a new production server. dbForge Studio for MySQL
provides robust database migration capabilities, as most popular MySQL-compatible cloud databases, storage and search engines are supported - including MariaDB, AmazonRDS, Amazon Aurora etc.
Databases can be transferred either within the same instance or between different instances, and there are three ways in which you can approach this:
Let's look at each one of them in more detail.
This method is the most simple and requires the fewest clicks. To copy a MySQL database to a new server, you will need to:
Learn more about the process of copying MySQL databases.
To backup a MySQL database and restore it on a different server, you will need to:
Learn more about the database backup process.
You can also use dbForge Studio for MySQL's built-in data import and export functionality to transfer databases between servers. To do this, you will need to:
Learn more about data import and export capabilities.
As you can see, dbForge Studio for MySQL has robust database migration capabilities for different cases and scenarios. The most simple way to transfer MySQL databases is to use the Copy Database functionality - only a few clicks are required in this case. However, the other ways we covered here can be used to achieve slightly more control over the migration process. You can try this out for yourself by downloading dbForge Studio for MySQL and testing the functionality described in this guide.
* The following functionality is not supported: backup projects, auto-deletion of old backup files, compression, and creation of backup files larger than 1MB.
** CSV format has no restrictions for data export and import; for other formats, only first 50 rows are processed. User templates are not supported.