Use mysqldump to create a backup of the database and use mysqlimport to read it into the new database.

As long as you didn't refer to the absolute URL in the code, all you should need to do is copy the database over.

If you want to use the same database, you can set the server in your MySQL connect statement to the other host. That's how I handle my test environment and test database.

FYI, if you are trying to have two different sites available to the public this is a bad idea as Google will hit you with a duplicate content penalty of some sort.

If you have 1 site and 2 domain names why not just add the other domain as a 'addon domain' to the server and you can access that 1 copy from both url's

If you want to copy the site to another server then generate a full back-up with mysql-grabs upload the mysql-dump and scripts at the neew server. the only thing you will need to then change/re-create will be the database name and user.


[PHP]$db = mysql_connect("localhost", "USERNAME", "PASSWORD") or Die("No connection establish to database: " . mysql_error());




mysql_select_db("DATABASENAME") or Die("DB Error !");[/PHP]


Hope this helps.