Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
The error message says right syntax to use near 'BINARY LOGS TO 'mysql-bin.xxx' but you mentioned use of PURGE MASTER LOGS TO ...?
Try using PURGE MASTER LOGS TO mysql-bin.xxx instead of using 'PURGE BINARY ....' as the latter was added to MySQL v4.1.1 and if your version is any lower, PURGE BINARY ... won't work.
PURGE MASTER LOGS TO mysql-bin.001 and got: 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 'mysql-bin.001' at line 1.
PURGE MASTER LOGS to 'mysql-bin.xxx'
CHARACTER SETsupport, plus lots of other things. It will be nontrivial to upgrade, which you should do. If you haveSELECTsthat mixJOINandLEFT JOIN, add parentheses now; there is an incompatible change coming.