Mysql Import and Export commands (Linux + Windows), mysql Import and Export

Mysql Import and Export commands (Linux + Windows), mysql Import and Export
Linux environment:

1. First, check the mysql Data Storage path:Ps-ef | grep mysql

 

　　

　　

Ii. Enter the mysql Data Storage path found above:Cd var/lib/mysql(Data Storage path)

　　

3. Use the mysqldump command to export the database

 

1. Export data and table structure:

Mysqldump-u username-p Database Name> file name. SQL

Example: mysqldump-u root-p database> database00001025. SQL (a prompt is displayed after you press Enter.Enter the password)

2. export only the table structure

Mysqldump-u username-p-d Database Name> database name. SQL

Example: mysqldump-u root-p-d database> database_nodata20171025. SQL

 

Si, import database:

1. Execute SQL statements to create an empty database;

Create database name;

2. Import the database;

Mysql-u username-p database name <database name. SQL

 

Windows Environment

1. First, check the mysql Data Storage path and execute the SQL statement: select concat (@ basedir, 'bin') as datadir from dual

 

Login, enter the system command execution interface (Win + R on the keyboard, Enter cmd), enter the address found on cd +, and press enter to enter the mysql Data Storage path. Example: cd C:/Program Files/MySQL Server 5.5/bin

 

Export and export the database using the mysqldump command:

1. Export data and table structure:

Mysqldump-u username-p Database Name> file name. SQL

Example: mysqldump-u root-p database> database00001025. SQL (enter the password when you press Enter)

2. export only the table structure

Mysqldump-u username-p-d Database Name> database name. SQL

Example: mysqldump-u root-p-d database> database_nodata20171025. SQL

 

Si, import database

1. Execute SQL statements to create an empty Database

Create database name;

2. Import Database

Mysql-u username-p database name <database name. SQL