tags 301976 + unreproducible moreinfo thanks Hello Karl
On 2005-03-29 Karl Hammar wrote:
> /etc/cron.daily/mysql-server:
> ERROR 1064 at line 1: You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near 'mysql-bin.010"' at line 1
> run-parts: /etc/cron.daily/mysql-server exited with return code 1
>
> Patch:
> - echo "PURGE MASTER LOGS TO \"$filename\";" | $M
> + echo "PURGE MASTER LOGS TO '$filename';" | $M
Thanks for reporting a problem but I doubt that this patch solves any
problem. MySQL does not distinguish between " and ' characters. Do you
have a normal log file or can you see in the binary logs, what command
the cronjobs did try to execute exactly?
If not, can you send me the output of
ls -al /var/log/mysql/
so that I can see if my script maybe has a problem with detecting what
$filename needs to be?
bye,
-christian-
pgppW0PqHm5XM.pgp
Description: PGP signature
