Move Your MySQL from AWS to a Vultr Managed Database

Learn how to migrate MySQL from AWS to a Vultr Managed Database using mysqldump or MySQL Workbench with real commands and clear instructions. Our MySQL Support Team is always here to help you.

Move Your MySQL from AWS to a Vultr Managed Database

Moving your database doesn’t have to be complicated. Many developers today choose to migrate MySQL from AWS to a Vultr Managed Database for better control, reliability, and lower cost. The process is straightforward once you know the right sequence. Let’s go through every part clearly and practically.

Migrate with mysqldump

The mysqldump utility comes pre-installed with the MySQL client. It’s one of the simplest ways to migrate MySQL from AWS to a Vultr Managed Database.

To check if mysqldump is available, run:

$ mysqldump --version

You should see something like:

mysqldump Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

Next, export your source AWS database to a single file. Replace example details with your actual database information:

$ mysqldump -h example.amazonaws.com -u example_user -p exampledb > migratetovultr.sql

Enter your password when prompted.

To export all databases at once, use the –all-databases flag instead of the database name after -p.

After the export, make sure the file exists in your working directory.

For Linux/macOS:

$ ls

For Windows PowerShell:

> dir *

Now, log in to your Vultr MySQL database:

$ mysql -h vultr-prod.vultrdb.com -u example-user -p

Enter your password, then create the target database with the same name as your AWS source:

mysql> CREATE DATABASE example-db;

Exit the console:

mysql> EXIT

Finally, import the exported data into your Vultr Managed Database:

$ mysql -h vultr-prod.vultrdb.com -u example-user -p < migratetovultr.sql

Enter your password once more to complete the import.

Migrate Using MySQL Workbench

If you prefer a visual interface, MySQL Workbench makes it easy to migrate MySQL from AWS to a Vultr Managed Database.

1. Download and install MySQL Workbench on your computer.
For large databases, you can create a temporary Windows Server on Vultr, install Workbench there, and perform the transfer with a stable connection.

2. Open MySQL Workbench and click the Migration button on the left panel.

3. At the bottom of the Overview section, click Start Migration.

4. Under Source & Target, keep MySQL selected as the Database System and Standard (TCP/IP) as the method.

5. In the Parameters section, enter your AWS source details:

• Hostname: AWS endpoint
• Port: 3306
• Username and password
• Click Next.

6. For the target, enter your Vultr database details and test the connection.

7. When the connection test passes, click Next.

8. Select the databases you want to move, then click Next to start reverse engineering.

9. In the Object Migration section, keep all Tables, Views, and Routines selected. Once conversion succeeds, click Next for Manual Editing (skip if no errors).

10. Once conversion succeeds, click Next for Manual Editing (skip if no errors).

11. Proceed to Target Creation options. Keep Create schema in target RDMS and Keep schemas if they already exist checked.

12. When prompted about existing tables, click Yes. If warned about system schemas, go back and deselect them.

13. Once schema creation completes, click Next and select Online copy of table data to target RDBMS.

14. Finally, review the report and click Finish.

Test and Confirm the Migration

Once the migration completes, verify that your data has moved correctly. Log in to your Vultr database:

$ mysql -h vultr-prod.vultrdb.com -u example-user -p

Check available databases:

mysql> SHOW DATABASES;

Switch to your imported database:

mysql> USE exampledb;

List the tables:

mysql> SHOW TABLES;

Inspect the data:

mysql> SELECT * FROM example-table;

Exit the shell:

mysql> EXIT

[If needed, Our team is available 24/7 for additional assistance.]

Conclusion

To sum it up, once you migrate MySQL from AWS to a Vultr Managed Database, you’ll have full control over your setup with improved performance and cost efficiency. After verification, simply update your applications to point to the new Vultr database and enjoy a stable, high-performing environment.