I need to set up regular cqrlog backups (preferably automatic).
The backup on exit doesn't work for me. It is not a priority to fix that because I rarely shutdown/reboot/exit-cqrlog.
I would prefer a backup method that allows me to automate a backup, maybe by middle of the night cron job, or similar.
I have tried this suggestion:
paul@paul:~$ (/usr/bin/mysql -B -N -e 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --databases) > /tmp/mycqrlogsdump.sql
Which resulted in:
Recent comments