MySQL Import Export command (linux+windows)

Linux Environment:

First, look at MySQL data storage path:ps-ef|grep MySQL

　　

　　

Ii. Enter the MySQL data storage path identified above:CD var/lib/mysql (data storage path)

　　

Export Database with mysqldump command

1. Export Data and table structure:

mysqldump-u user name-p database name > file name. SQL

Example: Mysqldump-u root-p Database > Database20171025.sql (will prompt for a password after hitting enter )

2. Export table structure only

mysqldump-u User name-p-d database name > database name. SQL

Example: Mysqldump-u root-p-D database > Database_nodata20171025.sql

Import Database:

1. Execute SQL statement to set up empty database;

CREATE database name;

2, import the database;

mysql-u user name-p database name < database name. SQL

Windows environment

First, look at MySQL data storage path, execute SQL statement:select concat (@ @basedir, ' bin ') as DataDir from dual

Daini, enter the system command execution interface (keyboard win+r, input cmd), enter the cd+ above the queried address , carriage return into the MySQL data storage path. Example: CD C:/Program files/mysql/mysql Server 5.5/bin

To export the database with the mysqldump command:

1. Export Data and table structure:

mysqldump-u user name-p database name > file name. SQL

Example: Mysqldump-u root-p Database > Database20171025.sql (will prompt for a password after hitting enter)

2. Export table structure only

mysqldump-u User name-p-d database name > database name. SQL

Example: Mysqldump-u root-p-D database > Database_nodata20171025.sql

Import Database

1. Execute SQL statement to establish an empty database

CREATE database name;

2. Import the database

mysql-u user name-p database name < database name. SQL

MySQL Import Export command (linux+windows)