Import/Export database using mysql/mariadb console

Sometime we got big database and stuck on the limit of phpMyAdmin upload limit, so here is the solution to import the big mysql file with command line:-

First login to the mysql/mariadb using command:-

mysql -u <username> -p <password> -h <hostname>

mysql> use <database>;

mysql> source <file path>

Now your importing will start.

Export database using Mysql/Mariadb

mysqldump -u root -p [password] [databasename] > database.sql
//User full path where you want dumb the database

Sometime Mysql/ Mariadb make all the table in lowercase for solving this issue you have to put some changes in your my.ini file:-

[mysqld]

lower_case_table_names=2