Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Location
    london
    Posts
    3

    Unanswered: accessing mysql on another server

    hello
    i have mysql installed on my pc. I would like to upload the data i have on my pc onto the server hosting my site. how do i go about doing this. i have downloaded mysql odbc and tried to use microsoft access to do this but to no avail. is there a way i connect using microsoft access or better still using mysql
    thanks

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    As long as your host has opened the MySQL port (usually 3306) to the world, you can do it by simply connecting from your client PC. ie.
    Code:
    INSERT INTO myremotetable@MyRemoteHostName.com
       SELECT * 
          FROM mylocaltable;
    You should be aware though that hosts don't usually open this port. You may need to ask them and have them grant permissions on the database for you IP address.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •