Hi Christian, it happened again :)
the directory /var/lib/mysql/test is back, it's empty, but it's back. It looks like this: [EMAIL PROTECTED]:~$ ll -d /var/lib/mysql/test drwxr-xr-x 2 mysql root 4096 May 16 08:25 /var/lib/mysql/test [EMAIL PROTECTED]:~$ The other directories in /var/lib/mysql belong to the group mysql... I have attached an excerpt from my syslog from the same time. I hope they're of value to you. They are different from what mysql usually writes into my log. Thanks, Thomas > --- Ursprüngliche Nachricht --- > Von: Christian Hammers <[EMAIL PROTECTED]> > An: "Thomas Schoepf" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Kopie: [EMAIL PROTECTED] > Betreff: Re: Bug#308456: mysql-server: dropped schemata keep reappearing > Datum: Wed, 11 May 2005 12:05:31 +0200 > > Hi Thomas > > On 2005-05-11 Thomas Schoepf wrote: > > It's a database. The MySQL Administrator calls it a Schema. > Ah, ok :) > > > > If so, just issue a "SHOW TABLES;" etc in the command line client or > > > look into /var/lib/mysql/ (if it's not innodb) to see if your files > > > really went away after you tried to remove them. > > > > The strange thing is that it does go away - temporarily. I looked into > > /var/lib/mysql and there was no directory "test" anymore after dropping > this > > database. But it reappears after several days to a few weeks. > > Take a look at the timestamp of the directory and the tables within (if > there are any tables) and cross-check that with the runtimes of your > cronjobs and /etc/cron.daily/*, /etc/cron.d/* and /etc/logrotate.*/* > (and of course with the times you fire up this administrator who might > think that he is in charge of recreating it...:)) > > bye, > > -christian- > -- 5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail +++ GMX - die erste Adresse für Mail, Message, More +++
mysql-syslog
Description: Binary data
