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 <password
And the import into AWS RDS pipe example:
mysqldump -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
Also the video tutorial demos how this is done:


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x