close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Copy site and database schema to another

Thread began 4/14/2010 10:45 am by mr hankey | Last modified 4/15/2010 2:06 pm by mr hankey | 573 views | 4 replies |

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

Sign in to reply to this post

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.

Sign in to reply to this post

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

Sign in to reply to this post

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.

Sign in to reply to this post

mr hankey

thanks jimmy

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...