Implementation code for PHP MySQL database replication

-- --Database: ' Db_copy_old ' -- -- --The structure of the table ' article ' -- CREATE TABLE IF not EXISTS ' article ' ( ' ID ' int (a) is not NULL auto_increment, ' title ' text character set UTF8 not NULL, ' Content ' text character set UTF8 not NULL, PRIMARY KEY (' id ') ) Engine=innodb DEFAULT CHARSET=GBK auto_increment=4; -- --Dump the data in the table ' article ' -- INSERT into ' article ' (' id ', ' title ', ' content ') VALUES (1, ' Test 001 ', ' Content 001 '), (2, ' Test 002 ', ' content 002 '), (3, ' Test 003 ', ' content 003 '); Copy Code 2, import the data from table article in database db_copy_old into the table article_new in the database db_copy_new to achieve replication between database tables: CREATE TABLE article_new like db_copy_old.article; INSERT article_new SELECT * from Db_copy_old.article; Copy Code

