Mysql Import and Export SQL FILE command 1 Enter cmd to enter the mysql directory, command: cdC: mysqlbin2 back up the smu database to the D disk root directory command: mysqldump-uroot-prootsmud: name. SQL import data: Enter cmd and type cdC: nvr2000mysqlbin3 to create the smu database mysqlcreatedatabasedata; 4
Mysql Import and Export SQL FILE command 1 Enter cmd to enter the mysql directory, command: cd C: \ mysql \ bin 2 back up the smu database to the D disk root directory command: mysqldump-uroot-proot smu d: \ name. SQL import data: Enter cmd and type cd C: \ nvr2000 \ mysql \ bin 3 to create the smu database mysqlcreate database data; 4
Mysql SQL File Import and Export commands
1. Go to cmd and enter the mysql directory. Command: cd C: \ mysql \ bin
2. Run the command mysqldump-uroot-proot smu> d: \ name. SQL to back up the smu database to the root directory of drive d.
Import data: Enter cmd and type cd C: \ nvr2000 \ mysql \ bin.
3. create an smu database mysql> create database data;
4. Import the database mysql-uroot-proot from disk D? Data <d: \ name. SQL