(09-17-2016, 10:57 PM)fastanddust Wrote: I need an automated program to backup my database from the web hosting server to my computer.
There are a number of options:
a. If you have a remote access to the database, you can do a cronjob/scheduled task to dump the database from the remote to your local. cue: mysqldump
b. make a master-slave db replication setup having your local as the slave.
c. monitor and exploit the audittrail table. All updates are tracked by this table and can be used to extract changes.