1. I manually deleted tables in order to free up disk space.
I deleted files prior to 24 July with names like: logs20070723.frm logs20070723.MYD logs20070723.MYI 2. When I tried the mysqldump command (mysqldump -d syslog > syslog.sql) as you've asked, I got the following error, which by the way is similiar to what I get on my browser, minus the "LOCK TABLES": mysqldump: Got error: 1016: Can't open file: 'logs.MYI' (errno: 145) when using LOCK TABLES 3. So, now I am with a DB that shows no tables within the syslog DB for anything prior to 24 July. oh and there is a file named logs.MYI: -rw-rw---- 1 mysql mysql 594248704 Aug 21 09:18 logs.MYI mysql> show tables; +------------------+ | Tables_in_syslog | +------------------+ | actions | | cemdb | | logs | | logs20070724 | | logs20070725 | | logs20070726 | | logs20070727 | | logs20070728 | | logs20070729 | | logs20070730 | | logs20070731 | | logs20070801 | | logs20070802 | | logs20070803 | | logs20070804 | | logs20070805 | | logs20070806 | | logs20070807 | | logs20070808 | | logs20070809 | | logs20070810 | | logs20070811 | | logs20070812 | | logs20070813 | | logs20070814 | | search_cache | | user_access | | users | +------------------+ 28 rows in set (0.00 sec) Thank you, and best regards, .vp >From: "Clayton Dukes" <[EMAIL PROTECTED]> >Vadim, >Can you possibly tell me exactly what you did so I can try to re-create the >error on my server (and work on a solution)? >i.e. Is your current database missing the logs table only? >Can you send me a dump of your table structure? >e.g.: > mysqldump -d syslog > syslog.sql >and send me that file (assuming the name of your DB is "syslog") > > >On 8/23/07, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > > > > Problems still persist, their have been two days worth of >logrorate.phprun. > > > > Thanks in advance, > > > > .vp > > > > > > >From: "Clayton Dukes" <[EMAIL PROTECTED]> > > > > >Hi Vadim, catch up with me tomorrow and I'll try to help out... > > > > > > > > >On 8/21/07, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > > > > > > > > Hmmm, not quite what I had wanted to hear :-) > > > > > > > > I was running logrotate.php in scripts, but even 30 days worth of >data > > >has > > > > become too much. > > > > > > > > Does anyone have another fix besides logrotate? I am having no luck > > >with > > > > it. > > > > > > > > Thanks, > > > > > > > > .vp > > > > > > > > > > > > >From: "Clayton Dukes" <[EMAIL PROTECTED]> > > > > >Reply-To: [EMAIL PROTECTED] > > > > >To: "Vadim Pushkin" <[EMAIL PROTECTED]> > > > > > > > > >Dude, you're so screwed...heh > > > > >Try running logrotate, I think that might help. > > > > >Also, in the future, there's a script in scripts/ for cleaning up >old > > > > >tables > > > > >:-) > > > > > > > > > > > > > > >On 8/21/07, Vadim Pushkin <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > All; > > > > > > > > > > > > OK, I screwed up, and I no longer use the logs.MRG file which > > would > > > > have > > > > > > been an easy fix for me. > > > > > > > > > > > > I've manually deleted several tables, older than 30 days, as my > > disk > > > > >space > > > > > > was overrun. Now I am not sure what to do and my initial page > > shows > > > > the > > > > > > following error: > > > > > > > > > > > > Query failed: Can't open file: 'logs.MYI' (errno: 145) > > > > > > > > > > > > Any help appreciated, I've already smacked myself. > > > > > > > > > > > > Many thanks, > > > > > > > > > > > > .vp ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
