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:

ERROR 1045 (28000): Access denied for user 'paul'@'localhost' (using password: NO)

So I tried:

paul@paul:~$ (/usr/bin/mysql -B -N -e --password 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --databases) > /tmp/mycqrlogsdump.sql

And get the same output:

ERROR 1045 (28000): Access denied for user 'paul'@'localhost' (using password: NO)

So I tried this (password substituted for illustration purposes):

paul@paul:~$ (/usr/bin/mysql -B -N -e --password=pppp 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --databases) > /tmp/mycqrlogsdump.sql

And still get the same output again.

So, I tried specifying both user and password in the command:

paul@paul:~$ (/usr/bin/mysql -B -N -e -upaul -ppppp 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --databases) > /tmp/mycqrlogsdump.sql

and get the following output:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1049 (42000): Unknown database 'show databases like "cqr%"'

So to check I did the following:

paul@paul:~$ mysql -upaul -ppppp

mysql: [Warning] ...... Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+
| Database |
+--------------------+
| information_schema |
| cqrlog001 |
| cqrlog002 |
| cqrlog011 |
| cqrlog012 |
| cqrlog013 |
| cqrlog014 |
| cqrlog015 |
| cqrlog016 |
| cqrlog_common |
| mysql |
| performance_schema |
| phpmyadmin |
| sys |
+--------------------+
14 rows in set (0.00 sec)

Does anyone know what I am doing wrong in the sql dump command, or is there a better way to backup the cqrlog databases?

73,