Importing / Update question

[msnhockey]

I have a database with my provider and my offline database using xampp

every now and again I need to update a table from xampp to my database with my provider

the tables are identical and both are big (approx 60,000 rows) what is the easiest way to update the table without exceeding or using all the max queries per hour (75,000)

I might not even hit that mark or I am not sure if using the import on the database counts towards that limit or not.

any suggestions are helpful.

thanks

[cretaceous]

Import the whole table via phpmyadmin?

[msnhockey]

cretaceous;11038481 wrote:

Import the whole table via phpmyadmin?

thats what i have been doing. wasnt sure if there was a better way or not

[dalecosp]

MySQL? You don't say.

Here, I have PHP-based shell scripts (and some of them are actual /bin/sh scripts) that use mysqldump, sftp, and so on to replicate DB's or tables from one host to another at specific times of day.