Help with publishing Dreamweaver site

Question

Hello guys, I give up looking for help everywhere else. Sorry for the dumb question but I am a noob.

I have built a Wordpress website with Dreamweaver CS5, everything works fine in my localhost. Also I have already set up my remote server and tested connection and everything and I know how to upload files to my hosting server, etc. The problem is that I have no clue how to also upload the MySql database that was built in my localhost and this makes some files from the website not get transferred to the remote sever. Can someone point me to some tutorials? That would be appreciated, Thanks.

Günter_Schenk · Accepted Answer

I guess this is the only way to do it?Yes, because no hosting provider could allow their customers to upload a MYSQL table in binary format and possible wreak havoc due to the table being damaged etc. Using phpMyAdmin instead is a pretty reliable safety precaution, as it will always check an uploaded SQL file for possible syntax errors and will display warning messages rather than let something buggy slip through I was thinking there would be an easier way to do it automatically through Dreamwearver.Well, adding such a feature would be a complex task which would inevitably increase a sales price which many Dreamweaver users will consider unjustified because they don´t need this feature.I updated my css file to test and when when I refreshed my web browser the change seemed to take effect.Did you possibly refresh the local preview instead of loading the remote document ?

Günter_Schenk · Answer

Which tool are you using to administrate your local MySQL database, phpMyAdmin by chance ?

The problem is that I have no clue how to also upload the MySql database that was built in my localhost

You need to use your local database administration tool for exporting the tables including the data to, say, an SQL text file. Next use use a browser to navigate to the remote server´s database administration tool (most likely phpMyAdmin) and use the Import function, which lets you upload the previously generated SQL file, what in turn will generate the tables and data on the remote server.

Most likely you will first need to create a database prior to importing the tables -- and if so, its name must be identical to your local database.

Can someone point me to some tutorials?

There are lots of tutorials around, and many of them are based on using phpMyAdmin. Try with googling "mysql database export" or "mysql database import".

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded