Accessing 2 DB on different servers

[mark_and_co]

Hey,

I am trying to build a Ringtones site and the content provider has given me username and password for their mysql db.

They have told me that I can only access their database once a day due to bandwidth issues so i need to copy all the data to my server every day.

My problem is that normally I get CSV files and it's really easy to get PHP to open the file and insert each row, however I'm wondering what is the best way of doing this.

Another problem is that their database is (obviously) on a different server so would I have to close the mysql connection and re-connect using my details? Would this work?

I appreciate your help.

Regards

[rachel2004]

"best way"?

If you have received a CSV file, "best way" IMHO is to use LOAD DATA command to have your MySQL db read the file and input the records into tables in your db. The MySQL manual shoud be able to give you full syntax for its usage. Be aware that you may have to play with the syntax for a few times before you have it working correctly. I'm telling you this beforehand so you can do all of yor practice on a development server before you duplicate the effort on your production server.

As far as your second question, try using

-h and -p in your MySQL connection parameters when you are attempting to connect to their MySQL server.

-h will allow you to specify the IP address of rington company's MySQL server.

-p will allow you to specify the port number of their MySQL server in case they are not using the default port of 3306.

Again, the MySQL manual will do a better of providing info than I can.