MySQL: How to sync on demand beetwen two database in the same server
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.