Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Copy site and database schema to another

Copy site and database schema to another

Thread began 4/14/2010 7:45 am by mr hankey | Last modified 4/15/2010 11:06 am by mr hankey | 1297 views | 4 replies |

4/14/2010 7:45 am | #1 mr hankey

Copy site and database schema to another

Hi,

I was wondering if anyone at WA or within the community have ever done this before.

Basically I have my site setup within dreamweaver connecting to my remote myssql database.

I want to use all the same layout of the site all the pages i have generated with WA extensions and take an sql dump file and create a new database in phpmyadmin and have the site connect to it?

not sure if i am explaining this properly.

I have just now say companyname.com which connects to mysql database called database1

i want to copy all the site files exactly the same as the above with a new database but same setup with tables so the pages i created with webassist extesions work.

so the new site would be say subdomain.companyname.com with database = database2

how easy is it to copy all this in dreamweaver so that the files all link to the new database?

is it a case of copying alll to the new site folder on web host and changing the includes connection file to the new database details?

or do i copy it to a new folde rlocally on my machine, open up one of the pages and create a new site and database connection and will dreamweaver automatically update all the connections to the new database?

hope someone can help,

many thanks

4/14/2010 11:03 am | #2 Jimmy Wu

If you update the connections file and upload the files to the correct place, with the correct directory structure, then it should connect correctly. Make sure you make a backup copy of your working site before making any edits first.

4/14/2010 12:07 pm | #3 mr hankey

thanks jimmy, so only the connections folder needs modified? all the recordsets etc will work?

have you or anyone else done this before?

many thanks

4/14/2010 1:33 pm | #4 Jimmy Wu

Yes, that should be the only thing you have to change. The pages should be created as relative links, so they're not site specific. I have set up a site on a local testing server and deployed it on a live server before, but I didn't change the database connection since it still connected to the same database server. As long as the connection is still called the same, the pages should still use it.

4/15/2010 11:06 am | #5 mr hankey

thanks jimmy

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.