Greetings. I've just returned from holidays, and it seems that all but 1 ibdata file ( there were 10! ) have been deleted by a co-worker. He apparently was able to delete them with nautilus ( he was looking to reclaim some space and these were 1GB files each ... and yes, the Trash was emptied as well ). I would have assumed these would be protected from being deleted while mysql was up, but this clearly wasn't the case ( or was it? perhaps they are still around? ).
The astonishing thing is that mysql doesn't seem to care about this. It happened 1 week ago, and no-one has complained about any database-related problems since. I've got a nightly backup script which does a 'mysqldump' on each database, and then restarts the server ( which gives me daily transaction logs ). Tonight, I obviously plan on doing a complete reinstall from an old backup, and running the transaction logs. But, just out of curiosity ... what the hell is going on? Why is mysql not complaining bitterly, crashing, and worse? Note the lack of ibdata1 ... ibdata9 screamer mysql # ls -l total 2885424 drwx------ 2 mysql mysql 480 Nov 26 2006 Assets drwx------ 2 mysql mysql 168 Sep 21 14:57 EPricing drwx------ 2 mysql mysql 12512 Sep 25 21:04 NUS drwx------ 2 mysql mysql 656 Nov 26 2006 Timekeeper drwx------ 2 mysql mysql 1216 Jul 4 08:46 dbmail drwx------ 2 mysql mysql 648 Aug 13 14:18 dspam drwx------ 2 mysql mysql 16584 Sep 18 09:32 ebills drwx------ 2 mysql mysql 824 Sep 24 14:45 energy -rw-rw---- 1 mysql mysql 5242880 Sep 26 09:08 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Sep 26 09:08 ib_logfile1 lrwxrwxrwx 1 root root 15112077312 Sep 26 09:08 ibdata10 drwx------ 2 mysql mysql 1848 Nov 26 2006 mysql drwx------ 2 mysql mysql 648 Dec 20 2006 roundcubemail drwx------ 3 mysql mysql 6240 Sep 26 08:54 sales -rw-rw---- 1 mysql mysql 239845598 Sep 14 20:40 screamer-bin.000201 -rw-rw---- 1 mysql mysql 591774120 Sep 17 20:44 screamer-bin.000202 -rw-rw---- 1 mysql mysql 289226895 Sep 18 20:38 screamer-bin.000203 -rw-rw---- 1 mysql mysql 281415790 Sep 19 20:36 screamer-bin.000204 -rw-rw---- 1 mysql mysql 286245722 Sep 20 20:37 screamer-bin.000205 -rw-rw---- 1 mysql mysql 331061564 Sep 21 20:43 screamer-bin.000206 -rw-rw---- 1 mysql mysql 411650198 Sep 24 20:38 screamer-bin.000207 -rw-rw---- 1 mysql mysql 309576301 Sep 25 20:37 screamer-bin.000208 -rw-rw---- 1 mysql mysql 140007700 Sep 26 09:08 screamer-bin.000209 -rw-rw---- 1 mysql mysql 3520 Sep 25 20:37 screamer-bin.index -rw-rw---- 1 mysql mysql 60432327 Sep 26 09:06 screamer-slow.log drwx------ 2 mysql mysql 80 Sep 20 11:16 test screamer mysql # The only way I can explain the fact that things are still working is that these files are in fact *not* deleted, and are still in use by mysql, but not visible to anything else. But that's ridiculous as well. So what's going on? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]