1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Windows XP' started by msnews, Aug 26, 2010.

  1. msnews

    msnews Flightless Bird

    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
     
  2. Greg Russell

    Greg Russell Flightless Bird

    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.
     

Share This Page