Syncing a database using an FTP dump

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mattpointblank
Forum Contributor
Posts: 304
Joined: Tue Dec 23, 2008 6:29 am

Syncing a database using an FTP dump

Post 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
Post Reply