Export MySQL file under Linux system

1, configuration: From centOS6.5 system, MySQL database

2. Commands for exporting. sql files:

Mysqldump-uroot-h116.228.90.147-p18006-p Aimo >/home/aimo.sql

3. Explanation:

I, Mysqldump is the utility that MySQL uses to go to the storage database. It primarily produces a SQL script that contains the commands necessary to recreate the database from scratch, create TABLE insert, and so on.

II,-uroot-u followed by user name

III,-h116.228.90.147-h followed by IP address, if it is local do not need to write this

IV,-p18006-p followed by port number

V,-p represents the database password, can be filled. If you don't fill in, you'll be filled in after you press ENTER.

VI, Aimo the name of the database to be exported

VII,/home/aimo.sql the address of the file you want to export and the filename

4, note: This line command to fill in the IP and port numbers and other parameters can be exported after any address of the MySQL database.

Export MySQL file under Linux system