> 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
MySQL do distinguish between them in ANSI mode. (See file:///usr/share/doc/mysql-doc/manual_toc.html#Extensions_to_ANSI) In default mode: mysql> PURGE MASTER LOGS TO "mysql-bin.010"; Query OK, 0 rows affected (0.00 sec) In ANSI mode: mysql> PURGE MASTER LOGS TO "mysql-bin.010"; ERROR 1064: 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 mysql> PURGE MASTER LOGS TO 'mysql-bin.010'; Query OK, 0 rows affected (0.00 sec) mysql> > 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? $ ls -al /var/log/mysql/ total 124 drwxr-s--- 2 mysql adm 4096 Mar 29 14:26 . drwxr-xr-x 31 root root 4096 Mar 29 06:31 .. -rw-rw---- 1 mysql adm 79 Mar 23 21:55 mysql-bin.010 -rw-rw---- 1 mysql adm 79 Mar 24 08:40 mysql-bin.011 -rw-rw---- 1 mysql adm 79 Mar 25 12:07 mysql-bin.012 -rw-rw---- 1 mysql adm 79 Mar 26 09:50 mysql-bin.013 -rw-rw---- 1 mysql adm 79 Mar 27 12:24 mysql-bin.014 -rw-rw---- 1 mysql adm 119 Mar 29 06:31 mysql-bin.015 -rw-rw---- 1 mysql adm 4 Mar 29 06:31 mysql-bin.016 -rw-rw---- 1 mysql adm 203 Mar 29 14:26 mysql-bin.index -rw-r----- 1 root adm 0 Mar 29 06:31 mysql.err -rw-r----- 1 root adm 20 Mar 29 06:31 mysql.err.1.gz -rw-r----- 1 root adm 20 Mar 22 06:31 mysql.err.2.gz -rw-r----- 1 root adm 20 Mar 21 06:31 mysql.err.3.gz -rw-r----- 1 root adm 20 Mar 20 06:31 mysql.err.4.gz -rw-r----- 1 root adm 20 Mar 19 06:31 mysql.err.5.gz -rw-r----- 1 root adm 20 Mar 18 06:31 mysql.err.6.gz -rw-r----- 1 root adm 20 Mar 17 06:30 mysql.err.7.gz -rw-r----- 1 mysql adm 0 Mar 29 06:31 mysql.log -rw-r----- 1 mysql adm 20 Mar 29 06:31 mysql.log.1.gz -rw-r----- 1 mysql adm 20 Mar 22 06:31 mysql.log.2.gz -rw-r----- 1 mysql adm 20 Mar 21 06:31 mysql.log.3.gz -rw-r----- 1 mysql adm 20 Mar 20 06:31 mysql.log.4.gz -rw-r----- 1 mysql adm 20 Mar 19 06:31 mysql.log.5.gz -rw-r----- 1 mysql adm 281 Mar 18 06:31 mysql.log.6.gz -rw-r----- 1 mysql adm 167 Mar 17 06:30 mysql.log.7.gz $ > > bye, > > -christian- Regards, /Karl ----------------------------------------------------------------------- Karl Hammar Aspö Data [EMAIL PROTECTED] Lilla Aspö 2340 Networks S-742 94 Östhammar +46 173 140 57 Computers Sweden +46 70 511 97 84 Consulting -----------------------------------------------------------------------
