close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Exporting Locally Created Database to Remote Hosting Server

Thread began 2/20/2011 12:56 pm by lynny | Last modified 11/30/2011 10:59 pm by jhnsmth166401290 | 2389 views | 5 replies |

lynny

Exporting Locally Created Database to Remote Hosting Server

Hi

I have created my database for ecart on my localhost testing server using XAMPP/PHPMYADMIN.

Im wondering how i export this database to my web host server (godaddy)?

Thanks

Sign in to reply to this post

Roxana

This is how I do it:

First I export an SQL file of the entire database (except orders and orderdetails). I do this using PHPMYADMIN. I open the database, hit the export tab, select SQL, and save it under the name given to me by my provider.

Then I log into the provider's PHPMYADMIN. They will have to give you a login name and password. From there I import the SQL file I just created.

Hope that helps.

Sign in to reply to this post

lynny

Hi Roxana

Thanks for taking the time out for the reply much appreciated! I have exported the database and imported to my hosting providers phpmyadmin but i am wondering what needs to be changed in the code of the pages that are dependent on the database, in order to connect to it and reference it? It is throwing up error messages saying that it cannot connect to localhost.

Cheers

Sign in to reply to this post

Roxana

You need to define the connection. In Dreamweaver there is an easy way to do that by clicking on the connection under the Databases tab in Application. Username, password and database will have to match with your providers settings.

I have attached a screen shot.

Then on each page, that refers to the database, you need to add this code above the head section:
<?php require_once('Connections/connYourConnectionName.php'); ?>

It has been a while, since I set up my own connection, so I am not sure, whether that is done automatically (when adding a recordset) or not.

I am not an expert, so this is just an educated guess :)

Sign in to reply to this post

Jason ByrnesWebAssist

dont create a new connection, just edit the existing connection that is already being used bu the local server and change the details to connect to the remote server. the n upload the connection file to the host.
Once this is done, switch Dreamweaver file panel to remote view, expand the connection folder and right click on the connection file and select Set Permissions. Uncheck the write option for all three groups.

You can then change the local connection file back to connection to the local server.

Sign in to reply to this post

jhnsmth166401290

Re:

In fully managed hosting plan, your website will be monitored by experienced webmasters on a regularly basis. Simply put, you don't have to worry about server downtimes and other technical issues. All you need is to pay and then receive updates from your managed hosting provider. You can sit back and enjoy. Managed Companies

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