I need to purge binary logs from mysql version 4. I have checked the manual found that the syntax is like an advanced versions:
PURGE MASTER LOGS TO mysql-bin.xxx
However, when i use this command, i get the following error:
ERROR 1064 (00000): 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 'BINARY LOGS TO 'mysql-bin.xxx'' at line 1
Please avdise.
CHARACTER SET
support, plus lots of other things. It will be nontrivial to upgrade, which you should do. If you haveSELECTs
that mixJOIN
andLEFT JOIN
, add parentheses now; there is an incompatible change coming.