MySQL

My applogise to the admin, didn;t quite know where to put this.

I'm trying to copy data from one database, to another. Both Db's have the same tables in them, and are laid out the same.

Just wondered if there was an easy way to do it. If not, then its a long night drinking coffee, and hitting my keyboard!

I use MySQL, but have never had to do this.

I think that as the tables are stored in seperate files, you may be able to simply move them as long as you have flushed and closed down the database. I'm not sure about how or if you would need extra configuration to get the new DB up and running. Your best bet would be to see the MySQL site itself. They have great support docs that would undoubtably give a better answer than anyone here.


MySQL