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

This article mainly explains "how to use the mysqldump command of Linux". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to use the mysqldump command of Linux.

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.

Syntax format mysqldump [parameters]

Common parameters:-- add-drop-table adds statements to delete database tables before each database table statement is created-- add-locks locks database tables when backing up database tables-- all-databases backs up all databases on the MySQL server-- comments adds comment information-- compact compression mode Produce less output-complete-insert output complete insert statement-databases specifies the database to back up-default-character-set specifies the default character set-force continues the backup operation when an error occurs-host specifies the server to back up the database-before lock-tables backup Lock all database tables-- no-create-db forbids the generation of database creation statements-- no-create-info forbids the generation of database table creation statements-- password for password connection to MySQL server-port number of portMySQL server-- user name reference instance for user connection MySQL server to export the entire database:

[root@linux265 ~] # mysqldump-u linux265-p smgp_apps_linux265 > linux265.sql exports a table in the database:

[root@linux265] # mysqldump-u linux265-p smgp_apps_linux265 users > linux265_users.sql Thank you for reading. The above is the content of "how to use the mysqldump command of Linux". After the study of this article, I believe you have a deeper understanding of how to use the mysqldump command of Linux, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.