Solved

how to purge binary logs on a 4.0.20 box

Posted on 2009-07-08
1
589 Views
Last Modified: 2012-05-07
hello,
i found the doc page
http://dev.mysql.com/doc/refman/4.1/en/purge-binary-logs.html

i tried (below) what am i missing??  

thanks
:::::

[root@millhouse root]# mysql --password mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24383 to server version: 4.0.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> PURGE BINARY LOGS BEFORE '2009-01-01 00:00:01';
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 'BINARY LOGS BEFORE '2009-01-01 00:00:00'' at line 1
mysql>



0
Comment
Question by:paries
1 Comment
 
LVL 30

Accepted Solution

by:
Kerem ERSOY earned 500 total points
ID: 24809661
Hi,

The problem is the syntax is valid for MySQL 4.1 and higher. You might like to use Reset master command instead.

Cheers,
K.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL: Get All Duplicates (not grouped) 3 49
Bubble user-defined Sql RAISERROR(...) to c# exception 14 144
Amazon Redshift 2 25
updating table data with inner join 9 24
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now