In news:eq2QUYPRLHA.5388@TK2MSFTNGP04.phx.gbl,
msnews <notinterestedgoaway@hotmail.com> typed:
> Is this possible? or do I have to create my dbs on the machine wamp
> is installed on. I want to connect to, access and develop my mysql
> dbs from my local machine, the same pc that I use dreamweaver to
> create my web pages on and then upload all to remote server.
>
> Any advice appreciated as I have posted to a couple of forums with no
> response so far.
Yes it's possible, just not advisable given your stated circumstances, as
you'll need the remote administrator's assistance in opening their firewall
to your database queries, as well as other configuration elements that are
defined in the my.cnf (Linux/Unix) mysqld or the my.ini if the remote server
is M$-based. The best answer I could give you is to study the syntax
elements in the WAMP my.ini file, and you can get help in
news:comp.databases.mysql or via
http://dev.mysql.com/doc/index-topic.html
You'll find it far easier though to simply make a backup of your remote
dataabase, get the file onto your local WAMP server, and then use phpmyadmin
to import it into your local WAMP mysqld database.
Work to your heart's content to make the code you're developing workable,
which will restrict any errors to only the local copy. Then, when
everything's working as desired, transfer your code to the remote server,
along with a copy of the local databse if desired.
It's a bad modus operandum to use a production database for development
purposes.
