close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Setting up a Database on Test Server

Thread began 2/16/2010 10:55 am by grgsr | Last modified 2/16/2010 6:37 pm by Dani Chankhour | 1843 views | 3 replies |

grgsr

Setting up a Database on Test Server

Hello:

I am using XAMPP for local testing. I would like to fully create my web site and database on my local machine. Once the site and database are completed I would then like to upload them onto a remote host.

I wondered how to set this up correctly on the local host. Where should my local host database be stored. Setting up the connection in Dreamweaver should be straight forward I just want to confirm where I should store the database on my local machine and if it would make a difference where it is stored?

I would change the connection settings when the site went live with the online host provider.

Thanks,
Glen

Sign in to reply to this post

Dani Chankhour

Do you need help setting up MYSQL(database) locally? Or are you wondering how you change database settings once you go live?

Sign in to reply to this post

grgsr

I want to create everything on a local machine until finalized then upload and go live. I just wondered if it may be necessary to have my DB in a sub folder in my root folder for the site or if it even matters.

Once the site is complete I would upload the DB to the host server and change the Dreamweaver settings to connect to it live.

Is this possible?

Thanks,
Glen

Sign in to reply to this post

Dani Chankhour

Yes, Once you are ready to switch to a live server, you can do a MySQL dump of your local database, and once you are live, you can import the dump to your live server and switch your connection settings to point to your live server.

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...