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

This article will explain in detail about using linux's mysqlhotcopy command to back up the database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

You can use the mysqlhotcopy command to back up a Mysql database, which uses FLUSH TABLES, LOCK TABLES, and cp or scp for database backup, which is a quick way to back up a database or table and is only used to back up MyISAM and ARCHIVE tables.

Syntax format: mysqlhotcopy [parameters] database name [. / regular expression of matching table /] [new database name | directory]

Common parameters:

Reference example

Backup the database www to the / root directory:

[root@linuxcool ~] # mysqlhotcopy www / root

Backup database www is database abc:

[root@linuxcool ~] # mysqlhotcopy www abc

Back up the database data1 of the host with hostname zx password p to the / www directory

[root@linuxcool] # mysqlhotcopy-u zx-p 123 data1 / www so much for backing up the database using linux's mysqlhotcopy command. I hope the above can be helpful and learn more. If you think the article is good, you can share it for more people to see.

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.