WAMP on remote xp server - how to create db from local machine?

  • Thread starter Thread starter msnews
  • Start date Start date
M

msnews

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.

regards
donna
 
In
msnews said:
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.
Click to expand...

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.
 
Back
Top