MYSQL Command line Import Export

1. Export MySQL Database

mysqldump-h[server address native can ignore]-u[user]-p[password-P[MYQL database port]> Export File location

mysqldump-h192. 168.18.  -uroot-pmiss-p3307 Mysql>d:\\new.sql

2. Import MySQL database files

mariadb[test]> usetestdatabase changedmariadb[test]>source d:\\new.sql

Precautions:

You may not be able to use the MySQL command after you install MARIADB and then switch to the bin directory of the MySQL installation directory to use it.

10.0\bin>

MYSQL Command line Import Export