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

This article will explain in detail how to use replication to modify the library name in mysql. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Replication modifies the library name

-- replicate-rewrite-db=from_name- > to_name

Command-Line Format-- replicate-rewrite-db=old_name- > new_name

Option-File Format replicate-rewrite-db

Permitted Values

Type string

Tells the slave to translate the default database (that is, the one selected by USE) to to_name if it was from_name on the master. Only statements involving tables are affected (not statements such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE), and only if from_name is the default database on the master. This does not work for cross-database updates. To specify multiple rewrites, use this option multiple times. The server uses the first one with a from_name value that matches. The database name translation is done before the-- replicate-* rules are tested.

If you use this option on the command line and the ">" character is special to your command interpreter, quote the option value. For example:

Shell > mysqld-- replicate-rewrite-db= "olddb- > newdb"

Applicable:

For example, master synchronizes the test library with slave, but this parameter is required because test needs to be renamed to testbak,master and cannot be changed because slave is required.

Add to my.cnf

Binlog-do-db=test

Replicate-rewrite-db=test- > testbak

Restart mysql and modify something in master's test library to see if slave's hackers library has been modified. Check to see if the show slave status is normal.

On how to use replication in mysql to modify the name of the library to share here, I hope the above content can be of some help to you, can learn more knowledge. 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.