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
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
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.
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
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 :)
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.
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
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.