I did a back up of a database (datbase_1),generated the dump file from database_1
I then created a new database database_2 and imported the dump file from database_1 into database_2 I then copied all the data files (located at mysql\data\database_2) from database_2 to database_1 Restarted database_1 and it worked ok with the original back up of database_1. While this all worked fine.....is there a more elegant way of backing up and then restoring a database? many thanks Joe
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]