Less than a month ago I enabled MySQL logging for BigSister and now find that the MySQL error log has grown to over 2GB since then. The reason is that only table.frm files got created and that's not enough when using InnoDB tables (which is the default in newer MySQL versions). So, a Myriad of error messages gets logged. The error is the second one as described on this page and there doesn't seem to be a fix other than deleting the tables: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html The creation process may be fine for MyISAM tables, but there still would be the MYI and MYD files missing and I think MyISAM needs these as well. So, is there a way to repair these tables somehow? (normal repair table operations won't help because the table simply "doesn't exist"). Furthermore, when investigating this I became suspicious that BigSister doesn't use MySQL logging, anyway. The tables are at 9KB and do not grow at all. Looking at them shows that there is no data in them. On the other hand, the files in var/graph still exist and get updated with data it seems. So, despite the MySQL lines that were uncommented in db.cfg and despite the fact that the tables got created (somehow, but incorrect) there is no MySQL logging going on. So, how do I *really* enable MySQL logging? Kai -- Kai Schätzl, Berlin, Germany Get your web at Conactive Internet Services: http://www.conactive.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bigsister-general mailing list suppressed https://lists.sourceforge.net/lists/listinfo/bigsister-general
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.