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

niljoshi September 2, 2014, 12:41am 6

^^^ Completely agree with Scott.nemes

Topic		Replies	Views
pt-table-sync two databases on the same mysql server? Percona Toolkit	1	2814	March 25, 2014
Binary Copy of InnoDB Files Sufficient? Other MySQL® Questions	3	1533	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	1126	January 18, 2023