Shulou(Shulou.com)06/01 Report--

This article mainly shows you "what is the use of the mysqldump command in Linux", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what is the use of the mysqldump command in Linux" this article.

Linux common commands mysqldump command is a backup tool in mysql databases, which is used to export databases in MySQL servers in the standard sql language and save them to files.

Backup tools in mysqldumpMySQL database

Syntax mysqldump (option) option-- add-drop-table: add statements to delete database tables before each create database table statement;-- add-locks: lock database tables when backing up database tables;-- all-databases: back up all databases on the MySQL server;-- comments: add comment information;-- compact: compression mode to produce less output;-- complete-insert: output completed insert statements -- databases: specify the database to back up;-- default-character-set: specify the default character set;-- force: continue the backup operation when an error occurs;-- host: specify the server to back up the database;-- lock-tables: lock all database tables before backup;-- no-create-db: disable the generation of database creation statements -- no-create-info: forbids the generation of statements to create database tables;-- password: the password to connect to the MySQL server;-- port number of the port:MySQL server;-- user: the user name to connect to the MySQL server. Instance to export the entire database

Mysqldump-u user name-p database name > exported file name mysqldump-u linuxde-p smgp_apps_linuxde > linuxde.sql exports a table

Mysqldump-u user name-p database name table name > exported file name mysqldump-u linuxde-p smgp_apps_linuxde users > linuxde_users.sql exports a database structure

Mysqldump-u linuxde-p-d-- add-drop-table smgp_apps_linuxde > linuxde_db.sql-d has no data,-- add-drop-table adds a drop table before each create statement

The above is all the content of the article "what is the use of mysqldump commands in Linux". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.