Hi everybody. This is a thread meant, surely, to stick.
As many others, I backup my customer's website daily.
Yet... if someday something goes really wrong... I can end up having a couple hundred intraday invoices lost in metaspace.
I would like to cron a process that backs up just the necessary data to add up to the system in case of failure.
What tables would you minimally backup, say, every 5-30 minutes?
How would you? With mysqldump or with a less heavy process.
For example:
ps_cart
ps_orders
ps_addresses
which more?
Maybe it is wise to save only registers that have been touched in the last 7 days?
SELECT * FROM ps_orders WHERE date_upd>"today minus 7 days"
Did anybody tried so? Any help will be appreciated.