MySQL Single Database mirror
I've got a quick question on how to do something. I need a way to replicate or mirror one database from a mysql server to another databata base on the same mysql server. The purpose is to keep the "second" database up to date, while I do development on a new theme/backend that I am working on. The core code isn't changing, so it won't actually mess up any tables or anything of that sort. I just need to same (up to date) content for the "development" database as the main (live) database that is actively serving content.
So, I need database1 to mirror database2 (both databases are on the same mySQL server).