random sub rosa
random work-related stuff that's useful to me...
Saturday, November 1, 2008
Purge Master Logs in MySQL
If the files '/var/log/mysql/server.bin.xxx' are large, you can manage them:
log into mysql as root. this is not the systems' root user, this is a different root user that is local to mysql.
# mysql -u root -p
mysql> purge master logs before 'xxxx-mm-dd 00:00:00';
To get today's date: `date +"%Y%m%d %H:%M:%S"`
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment