Shulou(Shulou.com)05/31 Report--

In this article, the editor introduces in detail "what are the characteristics of mysql logical backup", the content is detailed, the steps are clear, and the details are handled properly. I hope this article "what are the characteristics of mysql logical backup" can help you solve your doubts? let's follow the editor's way of thinking to learn new knowledge.

Backup is to query the MySQL server to obtain database structure and content information.

1. Backup is slower than the physical method because the server must access the database information and convert it to a logical format. If the output is written to the client, the server must also send it to the backup program.

2. The output is larger than the physical backup, especially the text format.

Backup and restore granularity can be used at the server level (all databases), database level (all tables in a particular database), or table level. This is the case regardless of the storage engine.

3. Backup does not include logs or configuration files.

Or other files unrelated to the database.

4. Backups stored in logical format are machine-independent.

Logical backups are performed while the MySQL server is running. The server is not offline.

Example

$mysqldump-h127.0.0.1-- add-drop-table-- force-u$DB_USER-p$DB_PASS $DB_NAME > $BACK_DIR/$NAME_sql$DB_USER # # indicates the user name $DB_PASS # # indicates the password $DB_NAME # # indicates the database to be backed up $NAME_sql # # indicates that the backup file name has been read here, and the article "what are the characteristics of mysql logical backup" has been introduced If you want to master the knowledge of this article, you still need to practice and use it. If you want to know more about the articles, you are 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.