accessing mysql on another server [Archive]

View Full Version : accessing mysql on another server

fol

02-04-02, 12:08

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

Paul

02-06-02, 20:25

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.

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.