MySQL: How to sync on demand beetwen two database in the same server I'll like to know if it's possible to have a systeme on synchronisation beetween two database in the same server.
I have a production database in my server , i want a dev database (same database with another name)
And i want to sync on demand.
Is it possible ?
As u told it possible to create another database(with different name) with in the server. try once in local db then you can go into production.