Dump data from MySQL to local

Method One: Use the mysqldump command, such as: Mysqldump-h10.90.6.237-uf_insplat2car_r-p3306-pxxxxxxxxx nbmp tb_tag_log--skip-lock-tables-- Set-charset--where= "Origin_chance_no like ' nbcar% '" > Dump.sql

Note that this method will lock the table by default during dump, and the lock table operation requires permission, if there is no lock table permission, you can add the "--skip-lock-tables" option declaration does not lock the table, but I did, still failed, prompt: couldn ' t execute ' SET OPTION sql_quote_show_create=1, discovered by Google, due to the low MySQL version of the client

Method Two: Use the MySQL query command to export the query results directly:

Mysql-h10.90.6.237-uf_insplat2car_r-p3306-pxxxxxx--default-character-set=utf8--skip-column-names-b-E "SELECT * fr Om nbmp.tb_tag_log where origin_chance_no like ' nbcar% ' "> Dump.txt

Dump data from MySQL to local