MariaDB isan open-source relational database management system commonly used in applications. With Kinsta’s Database Hosting, you can easily add a new MariaDB database from the dashboard, clickDatabases>Add databaseand select the required options.
If you have an existing database locally or with another hosting provider, you can import the MariaDB database into Kinsta’s Database Hosting using a third-party database tool or the Command Line Interface (CLI).Note:To import a database, you must create a new database in MyKinsta first.
Import a MariaDB database using a database tool
There are many database tools you can use to connect and manage your database; we have step-by-step instructions forTablePlus, as this tool allows you to manage all the database types you can host on Kinsta.
You can use any database client or tool that supports your database type. While some specifics, like navigation and field names, may vary between database tools, the fundamental concepts are the same.
Import a MariaDB database using the command line interface (CLI)
You can use the command line interface (CLI) to import your MariaDB database into Kinsta. The installation of the database server and commands vary for each database type. This article is specific to MariaDB. For other database types, see:
If you do not yet have MariaDB installed on your local machine, you’ll need to install it to connect to your database. Depending on your operating system, you can install MariaDB in the following ways.
You can find your database credentials underExternal connectionson the databaseOverviewpage.
Import a MariaDB database
Use the following command to export the database, replacing EXTERNAL_HOSTNAME, USERNAME, PORT, and DATABASE_NAME with the information from your database’sExternal connections. Replaceexport.sqlwith the path and name of the database you want to import:
No output will be produced unless there are errors, which will be printed to the command line. To verify a successful import, you can useSHOW TABLES; or a similar command to review the data in your database.
Export a MariaDB database
Use the following command to export the database, replacing EXTERNAL_HOSTNAME, USERNAME, PORT, and DATABASE_NAME with the information from your database’sExternal connections. Replaceexport.sqlwith the path and file name of the database you want to export:
Once the export is complete, your database file (e.g.export.sql) will be available at the path you specified in themariadb-dump command. You can open the file with aplain text editor(e.g. TextEdit, Notepad++, Sublime Text, etc.) or a database tool like TablePlus to review the exported data.
We care about your privacy
We use cookies for analytics and improved functionality to improve your website experience.