LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 03-04-2008, 10:48 AM   #1
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Rep: Reputation: 39
Question MySQL logging server how can i 'log rotate' all the data


Hi All,
I'm looking for a decent method of rotating data in a MySQL table that has log files piped into it from a few different servers. Basically one of the most important things is that the table or MySQL doesn't stop running so that the servers logging to it are always able to connect and send any log message to the MySQL database, 24/7. I'd like to be able to archive off the logs for a date and also every so often run a clean down of the table. My thoughts were a mysqldump with a where clause in it to specify the date range, and then to clean out the table every so often to truncate the table. Basically i need to make sure i don't loose any data at the times of this happening so does this sound like a good method or are there other methods that may be better.

Cheers,
Mark
 
Old 03-31-2008, 04:48 AM   #2
helptonewbie
Member
 
Registered: Aug 2006
Location: England Somewhere
Distribution: Mandriva, PCLinuxOS, Karoshi, Suse, Redhat, Ubuntu
Posts: 518

Original Poster
Rep: Reputation: 39
no ideas anyone.. this has me stumped?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Logging SNORT Data to Mysql Database ALInux Linux - Software 4 03-18-2008 12:16 PM
cannot delete or rotate messages log file dan451 Linux - Newbie 14 08-04-2006 04:13 PM
need software to batch-rotate jpeg's based on exif data mfcarroll Linux - Software 3 03-07-2005 02:39 PM
Log Rotate MaverickApollo Linux - Software 3 01-19-2004 12:12 AM
[PHP+MySQL] Rotate order in SELECT pnh73 Programming 5 12-31-2003 04:10 PM


All times are GMT -5. The time now is 02:06 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration