If you had been building the content for your new WordPress site on a Raspberry Pi 3, there will come a time when you need to migrate the underlying MySQL database to another machine, for eg. a DigitalOcean droplet, for production usage.
MySQL provides us with the mongodump client utility to produce a set of SQL statements that can be executed to reproduce the original database object definitions and table data.
A simple MySQL database migration can be performed with the following steps:
- Use mysqldump to get the set of SQL statements that can be executed to reproduce the original database object definitions and table data.
- If the mysqldump output is too big, use the
tarcommand to compress it.
- Use the
scpcommand to send the mysqldump output from the source server to the destination server.
- If you had used the
tarcommand to compress the mysqldump output, use the tar command at the destination server to decompress it.
- Execute the set of SQL commands in the
mysqldumpoutput at the destination server.
This post documents how you can migrate your MySQL / MariaDB database with utilities provided by MySQL and most Linux servers.