How to Recreate the same Database to the Different Machine

**DayanandPatil** · 30-01-2009

I have all the data stored in my MySQL database and I am trying to moving it. I'm creating an install script (PHP) that will create the database on the new machine.

The problem is that when I go to phpMyAdmin and export the database, the views have database/user specific information in the create statement. Is there a simple way to remove them? (or a simpler way to create this script?) or will I have to go and hand retouch them all?

**Samra** · 30-01-2009

In phpMyAdmin export uncheck the box next to data and you'll only get the database structure.It only takes a moment to remove all other data in the .sql file and leave only the create table statement. just open it in a text editor.

**Pauline** · 30-01-2009

Before you attempt the restore, right click on the destination database and click properties. Look at the Files tab and see what the physical path is to the .MDF and .LDF on that server. Then, when you do the restore, on the same screen where you force the overwrite, make sure the file path matches the destination server.