Page 1 of 1

Syncing a database using an FTP dump

Posted: Thu Mar 04, 2010 3:37 am
by mattpointblank
Hi all,

Working on a webstore app for a client. His (physical) shop uses Actinic software to power its till, which runs off a (local) Access database. He can't put this database online (Actinic license a network version of their software but he can't afford it) so the best thing he can offer me is a nightly SQL dump uploaded via FTP. This backup seems to be in the format of a series of .MDB files (only one of which is relevant) in a .ZIP file, and I only need the contents of one table from this database.

Has anyone got any experience with doing something like this? Is it even possible to run some sort of cron job that would take this .sql file and overwrite the old (MySQL) database with it? Anything I should watch out for?

Thanks
Matt