Mysqldump command note -- opt

Mysqldump command note -- opt

Mysqldump-uroot-p -- opt DATABASENAME [Table]> xxx. SQL

 

By default, the SQL file exported by Mysqldump contains not only the exported data, but also the structure information of all data tables in the exported database. -Opt: This Mysqldump command parameter is optional. If this option is included, quick, add-drop-table, add-locks, extended-insert of the Mysqldump command are activated, the lock-tables parameter, that is, when using Mysqldump to export Mysql database information using the-opt parameter, you do not need to attach these parameters. -Quick: Ignore the buffer output. The Mysqldump command exports data directly to the specified SQL file. -Add-drop-table: add the DROP-table if exists statement before each create tabel command to prevent duplicate data tables. -Add-locks: indicates to LOCK and UNLOCK a specific data table before and after the INSERT data. You can open the SQL file exported by Mysqldump and the LOCK TABLES and UNLOCK TABLES statements will appear before the INSERT operation. -Extended-insert (-e): This parameter indicates that multiple rows can be inserted.