As following scenario shows, the problem occures really because of a oviously invalid table which I backuped inside the mysql data directory:
Test1) Before starting the problematic mysql server security release (5.1.41-3ubuntu12.3) by "start mysql" the mysql data directory shows following entries: debian-5.0.flag ibdata1 ib_logfile0 ib_logfile1 mysql mysql_upgrade_info tcexam tcexam9 tcexam.bak1 zm Mention the entry "tcexam.bak1" which is an exact copy of the "tcexam" table directory. (identical according a "diff -r" and also the access rights are same. Possibly I copied the table manually some years ago by a "cp -a tcexam tcexam.bak1" - I didn't use these two tables since then because I'm working now on another table "tcexam9"). After starting the mysql-server (release 5.1.41-3ubuntu12.3) the only directory entry left is: "tce...@002ebak1" So a l l t a b l e s d i s a p e a r e d - including table mysql and all other tabels! Test2) After restoring the directory from the backup and deleting "tcexam.bak1" manually before starting the mysql-server, all is working fine. Test3) After that I did another test with the now working setup: I stopped the mysyl-server, copied "tcexam" now manually by a "cp -a tcexam tcexam.bak1" and started mysql again - but now the problem doesn't happen again! (But of course I can reproduce it by resoring the original directory content.) As I mentioned, this happens only with mysql-server-5.1 5.1.41-3ubuntu12.3, not with older releases! At last I looked into the subdirectory "tce...@002ebak1" and what surprise all the tables are there: db.opt ibdata1 ib_logfile1 mysql_upgrade_info tcexam9 zm debian-5.0.flag ib_logfile0 mysql tcexam tcexam.bak1 Strange isn't it? Regards Matthias -- mysql-server-5.1 deletes tables on start https://bugs.launchpad.net/bugs/593552 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
