Help with publishing Dreamweaver site

[George Orellana]

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]

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

[George Orellana]

Hello, Thanks for your reply. Yes I am using phpMyAdmin. I did what you say a few hours ago and it worked fine. I guess this is the only way to do it? I was thinking there would be an easier way to do it automatically through Dreamwearver.

On another note, I just turned on the "Automatically upload files on Save" option under my remote server configuration. I updated my css file to test and when when I refreshed my web browser the change seemed to take effect. However the log on Dreamweaver says "did not transfer file" and the css file in my server has indeed not changed. Any idea what is going on there?

[Günter_Schenk · Accepted solution]

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 ?

[George Orellana]

I see what you are saying that makes sense. Not sure what the deal with the upload was. Nonetheless I have decided that the easiest and most practical way of uploading and updating files to the remote server is by using Filezilla. Dreamweaver is still good for editing and creating my themes, and I can always change a file directly on the remote server by being connected to it.

Thanks for your responses you have been great help.