Exporting and Importing MariaDB Databases
MariaDB is a community-developed fork of the MySQL relational database management system and is used at Opalstack to provide MySQL-compatible database services.
This document shows how to export data from, and import data to, your MariaDB databases on Opalstack. The examples use mydb
as the database name, mydbuser
as the database username, and mydb.sql
as the filename for the imported/exported data - be sure to replace those values with the names of your own database and database user.
You can export a MariaDB database by executing the following command in a SSH session on your Opalstack server:
mysqldump -p -u mydbuser mydb > mydb.sql
Enter your MariaDB database user password when prompted.
When the command is complete, the exported data will be stored in the file mydb.sql
in your SSH session's current working directory.
You can import a MariaDB database by executing the following command in a SSH session on your Opalstack server:
mysql -p -u mydbuser mydb < mydb.sql
Enter your MariaDB database user password when prompted.
When the command is complete, the imported data will be stored in your mydb
MariaDB database.