How to Migrate a MariaDB to AWS RDS MariaDB with myqldump
In this post we will demonstrate how to migrate a MariaDB Database to AWS RDS MariaDB database using mysqldump utility.
Here is the mysqldump export code used:
mysqldump -u <user name --databases <db name --single-transaction --order-by-primary --gtid --force -r <dump file location -p <passwordmysqldump -u <user name --databases <db name --single-transaction --order-by-primary --gtid --force -p <password
| mysql -u <AWS RDS username -P <AWS RDS port -h <AWS RDS Endpoint -p
