2.4k questions

2.4k answers

98.0k users

12 Online Users
1 Member 11 Guest
Online Members
Today Visits : 1247
Yesterday Visits : 1735
Total Visits : 2425244

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
44 views

How do you import a MariaDB database?
in General by (95.8k points)

1 Answer

0 votes

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.

by (95.8k points)
...