Forum

Notifications

Clear all

How do you import a MariaDB database?

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:04 pm

How do you import a MariaDB database?

Quote

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 18/10/2024 7:05 pm

From command lineCommand line MySQL import (Mariadb is a FREE Mysql)
[list=1]

Type: mysql -u username -p database_name < file.sql.

The username refers to your MySQL username.

database_name refers to the database you want to import.

file. sql is your file name.

If you've assigned a password, type it now and press Enter.

You can also import, using tools, like phpadminImporting to MySQL/MariaDB Databases with phpMyAdmin
[list=1]

Open the target database for editing with phpMyAdmin.

Click Import in the menu bar. ...

In the File to import: section, click Select file and select your backup file.

Specify the desired import settings. ...

Click OK to start the import.

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

ReplyQuote

Share: