Database Migration Service troubleshooting

Prev Next

Available in VPC

Learn how to resolve issues with Database Migration Service. Click any error for detailed troubleshooting steps.

Troubleshoot common issues

The following are examples of common errors you might encounter:

Migration error
Migration was not performed.

Migration incomplete
All migration steps, including replication, have been completed, but the status is displayed as "migration" in the Cloud DB for MySQL console.

Migration error on definer account set in source DB
The definer account that is set in the source DB was not automatically created during migration.

DB Config settings not migrated
DB Config settings were not migrated.

Test Connection delay
Test connection takes too much time.

["Killed You can't use 'macro parameter character #' in math modeRESTORECMD" error message](/docs/en/dms-troubleshot-common#KilledRESTORECMD오류메시지) Backup type: "Killed RESTORECMD" error popup appears when using mydumper.

Permission error
An insufficient privileges message is displayed.

DB access setting problem

The following are examples of DB access errors you might encounter:

Source DB and Target DB server communication error
Source DB and Target DB servers are not communicating.

Source DB access error
Attempted Test Connection but cannot access Source DB.

Display DB ACL check message
When trying Test Connection, DB ACL check message displays.

BACKUP_ADMIN/RELOAD permission
I want to use mydumper method, but I recieved the message BACKUP_ADMIN/RELOAD permissions.

Migration between DBs of different versions

The following are examples of migration errors you might encounter:

Compatibility issue
When migrating from the lower version of MySQL to the higher version, a compatibility issue occurs.

Error when migrating from Source DB MySQL version 5.7 and MariaDB version 10.1 or later to Target DB MySQL version 8.0
Error occurs when migrating from Source DB MySQL version 5.7 and MariaDB version 10.1 or later to Target DB MySQL version 8.0.

Replication consistency issues with MySQL 5.7.40
Replication consistency issues occur in MySQL version 5.7.40.

"Collations unsupported in Target DB are included." Troubleshoot error messages
"Collations unsupported in Target DB are included." The error message appears.

Learning resources

We offer various materials for you to explore. To learn more about Database Migration Service, check out these helpful links:

Note

If you're still having trouble finding what you need, click on the feedback icon and send us your thoughts and requests. We'll use your feedback to improve this guide.