> Baron Schwartz wrote: >> Hi Joseph, >> >> Joseph Koenig wrote: >>> Hi, >>> >>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I >>> moved the >>> data directory of MySQL. I updated everything that SELinux complained >>> about, >>> etc., and have a functional install of MySQL. It's actually been up and >>> running with no issues for months. However, every time I run a >>> mysqldump, I >>> get: >>> >>> mysqldump: Got error: 1017: Can't find file: 'general_log' (errno: 2) >>> when >>> using LOCK TABLES >>> mysqldump: Couldn't execute 'show create table `general_log`': Can't >>> find >>> file: 'general_log' (errno: 2) (1017) >>> mysqldump: Couldn't execute 'show create table `slow_log`': Can't >>> find file: >>> 'slow_log' (errno: 2) (1017) >>> >>> My dump proceeds and just spits these errors out to me. From what I can >>> tell, no harm is done, as the dump is full and is perfectly usable for >>> restoring databases from. However, it's driving me nuts. Is there any >>> way to >>> create the necessary tables now so that MySQL does actually start >>> logging >>> everything they way it should be able to and also will make these >>> errors go >>> away? Thanks in advance, >> >> It's a hard to tell from this description what is the matter. Can you >> connect via mysql and run "SHOW CREATE TABLE slow_log" without >> errors? If so, what storage engine do they use? It sounds to me like >> they might be using the CSV storage engine and the file isn't there. >> Error 2 is 'OS error code 2: No such file or directory' according >> to perror. >> >> You probably don't want to mysqldump a big CSV file of your general >> log, at least not if you're using this for backups (but maybe you do, >> I don't know). >> >> In short, you might want to DROP the tables instead of creating them. > > It looks like there was a 5.1 installation here at some point - 5.0.37 > should not include the general_log or slow_log tables - these are 5.1 > new features. > > I suspect that you likely have general_log and slow_log frm files within > the mysql database directory, without any corresponding data files. If > this is the case then just 'rm' the general_log.frm and slow_log.frm > files from the mysql database directory, and all these errors should go > away. > > Cheers, > > Mark
Brilliant! You are absolutely right - I had installed 5.1 at one point, realized it was still alpha and went back to 5.0.27. I got rid of the .frm files and all is well. Thanks! -- Joseph Koenig Creative Anvil, Inc. Ph: 314.773.2611 FX: 314.773.2942 http://www.creativeanvil.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]