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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

database remote connection

Thread began 9/29/2009 6:03 pm by segalmedia367166 | Last modified 9/30/2009 3:59 pm by Office-172461 | 837 views | 2 replies |

segalmedia367166

database remote connection

OK, I know that the answer is probably right in front of me, but I can't figure out how to get my remote server to connect to my database. I am all good with my local server. I uploaded my site to godaddy. I can see my pages fine. It is not drawing from the database (dynamic menu not finding products, etc). I created a database in godaddy with the same name as my local one, i imported the store.sql file from the local database, checked online, but it did not fix my problem. Can you advise? I have a feeling that the answer is really quite simple.

Regards,

Lisa
P.S. does the store.sq file "house" all the data that I have entered? If not, where is it?

Sign in to reply to this post

Eric Mittman

I think there are two things that you will need to do to get the info ported to your live server. The first thing you need to do is export your data from your local environment. As you noted the store.sql file is empty of content, it is just the structure. Most MySQL GUI tools will allow you to export the db as an sql file. You should then load this file into your live db.

The other thing to pay attention to is the name of the db on the live server and how you connect to it with the username and password. You will need to ensure that the connection file you have on the live server lists the details for the live db and not your local one.

If you have these two things taken care of I think you site will work just fine for you on your live server.

Sign in to reply to this post

Office-172461

This might help

Exporting and Importing a database using phpMyAdmin

150/

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