Using Data Assist

Sorry if this is not the correct or best forum for this question.

I have just purchased the Dynamic Suite and was experimenting with it.

I was unable to connect to my remote server via DW CS3, and am now understanding that I need to build everything on my testing server, then I assume upload the files, change the connection parameters and import the database tables? Is this correct?

I am using (as well as my host) phpmyadmin, so again, I am assuming that I will export the existing tables/data from my remote server, then import to my local testing server, once I am done with the additions I make using WA, then export from the local and import to the remote? Am I correct on this or is there a better way? Perhaps there is a tutorial or two about this?

Thank you for your help.

Gary

Gary,

With the connection to the remote server, many hosting companies do not allow remote connections. Some will allow you to add your IP has a host that is allowed to have access to the MySQL on the hosts's server so that you can use a GUI app other than PhpMyAdmin to connect from your desktop.

Either way, the best practice for me has been to set up my testing server on the local machine to mirror my production server exactly. My production server uses "localhost" to access MySQL and so does my testing server... so I actually only declare the variables once and then just FTP my entire site. I then dump the local machine mySQL and then import to the production server. That way, everything on my local machine is exactly how it will appear online in the production environment.

The key is to make the local machine's MySQL be exactly the same - same database name, same user name, same password, etc.

Best regards,

Brian

Brian

Thanks for your reply. That seems to make sense.

Gary