script to auto update/ import records

Hi Guys, I have a challenging question for you…

AIM – Import a database of listings every night to replace all existing listings
REASON – Our main database of members is held on one site, we then want to refresh and update a serious of feeder sites overnight every night (to account for new members and expired ones)

Ideally we would do this via a cron job and MySQL – Empty the relevant tables, then populate them with the new data. If you have any experience with this then please share the script or notes

Is there a list of which tables hold the listing info? (we don’t need to change any WP user info as the way we have constructed our sites is that all listings belong to one single user)

If you can supply a list o the relevant tables, then we would aim to get the cron to empty those tables and then re-populate them with suitably formatted contents. In theory this should work right?

Alternative option would be to have a cron empty the relevant tables, then we re-populate with a Mac Automator process, which will produce the CSV, go into the admin GUI and do a regular import, like you would under normal import situations. Bit more primitive this way, but should work fine if there’s no way to import using MySQL

Any clues or tips please?

Thanks!

Pete