MySQL database import and export method under Linux environment

Export the entire Database all the data in

1. Under the Linux command line, enter:

Mysqldump-u username-p dabasename > Filename.sql

Filename.sql Better Add path name

To export data from a table in a database

Mysqldump-u username-p dabasename tableName > Filename.sql

Export all the table structures in the entire database

on the linux command line, enter:

Mysqldump-u username-p-D dabasename > Filename.sql

Note: The-D is added.

Export the table structure of a table in the entire database

on the linux command line, enter:

Mysqldump-u Username-p-D dabasename tableName > Filename.sql

Note: The-D is added.

Import MySQL Method 1

go to the linux command command line:

Mysql-uroot-p return Enter password

SOURCE Filename.sql

Note that filename.sql should have pathname, for example:source/home/user/data/filename.sql

Import MySQL Method 2

go to the linux command command line:

Mysql-uroot-p Database < Filename.sql

Note that the Filename.sql must have a path name

MySQL database import and export method under Linux environment