I have one database for production and another for dev. All test will be on test. until here , there is no problem. But i want to sync the dev database with prod database on demand (for example every night , or if there are issues…) Is it possible ?

How to sync on demand between two database in the same server mysql

saidassoumani August 28, 2014, 4:39am 3

Hi @niljoshi ,
First , Thank for you reply.
I use Innodb for the two databases.
There is no tool or script that allow me to sync my dev database with my prod database on demand without backup?
(to have the same state as the production)

Topic		Replies	Views
pt-table-sync two databases on the same mysql server? Percona Toolkit	1	2815	March 25, 2014
Binary Copy of InnoDB Files Sufficient? Other MySQL® Questions	3	1534	October 12, 2015
Setting up a development environment Percona XtraDB Cluster 5.x	1	603	December 12, 2013
Problem Percona Server cluster! Other MySQL® Questions	0	370	February 21, 2019
How to sync XtraDB cluster with other database Percona XtraDB Cluster 5.x	3	1127	January 18, 2023

How to sync on demand between two database in the same server mysql

Related topics