Different local & remote MySQL server names

Report · Apr 22, 2006

My local test server is "localhost" and my remote MySQL server is "abc.defgh.co.uk". Connections to both work OK, but I need to change the MySQL Server name in the MySQL Connection dialogue box depending which server I'm using, as there's only room for one of the server. I can't change the remote MySQL server name to "localhost" and the remote serve won't accept connections from elsewhere. I don't want to have to change the server name everytime I change between testing and uploading. Any suggestions?

Thanks

Report · Apr 22, 2006

Andrew__C wrote:
> My local test server is "localhost" and my remote MySQL server is
> "abc.defgh.co.uk". Connections to both work OK, but I need to change the MySQL
> Server name in the MySQL Connection dialogue box depending which server I'm
> using, as there's only room for one of the server. I can't change the remote
> MySQL server name to "localhost" and the remote serve won't accept connections
> from elsewhere. I don't want to have to change the server name everytime I
> change between testing and uploading. Any suggestions?

Open your local connection file and edit the values. Save the file with
a different name, and upload it to your remote server. On the remote
server rename it to use the same name as locally. That gives you
different connection parameters, but keeps the file names and relative
links the same on different servers.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Apr 22, 2006

Thanks for the response. I'd already thought about this solution, however, everytime you want to upload dependent files - including new recordsets etc, the connection details are also overwritten.

Report · Apr 22, 2006

Andrew__C wrote:
> Thanks for the response. I'd already thought about this solution, however, everytime you want to upload dependent files - including new recordsets etc, the connection details are also overwritten.

Don't upload dependent files, then.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Apr 22, 2006

Thanks for reply; although it's not very helpful and it doesn't provide a solution.

Report · Apr 22, 2006

Andrew__C wrote:
> Thanks for reply; although it's not very helpful and it doesn't provide a solution.

It's the most practical solution available. I find the automatic
uploading of dependent files takes away too much control from me.
However, if you prefer to work a different way, put in a feature request
to the Dreamweaver development team. Tell them that you want the ability
to exclude connection files from automatic uploading of dependent files.

Something that many people either don't realize or forget is that this
is a user-to-user forum. If you don't like the way Dreamweaver works, or
have suggestions about how to improve it, the only way to influence
future developments is to use the proper channels:

www.macromedia.com/go/wish

The development team does listen.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

Report · Apr 23, 2006

Thank you for your comments and suggestion. It seems that a fully satisfactory solution is not available and I will continue with a work-around, which is not a problem just an occasional hassle. I did however follow the suggestion of putting in a wish-list request.

Again thanks for the input, which confirms my own thought that I couldn't do what I wanted in the way I wanted.

Regards Andrew

Report · Apr 22, 2006

In all fairness, it is the solution. Well, it's the solution I use too. That
is - my remote and local sites will be identical apart from the connections
file.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004