Question

How do you import a MariaDB database?

Answer 1

From command line

Command line MySQL import (Mariadb is a FREE Mysql)

1. Type: mysql -u username -p database_name < file.sql.
2. The username refers to your MySQL username.
3. database_name refers to the database you want to import.
4. file. sql is your file name.
5. If you've assigned a password, type it now and press Enter.

You can also import, using tools, like phpadmin

Importing to MySQL/MariaDB Databases with phpMyAdmin

1. Open the target database for editing with phpMyAdmin.
2. Click Import in the menu bar. ...
3. In the File to import: section, click Select file and select your backup file.
4. Specify the desired import settings. ...
5. Click OK to start the import.

Another way is to write programs in a language like PHP.