MySQL down on debian 6.0.7

Hi,

Suddenly my MySQL refuses to run for no reason understandable for me :-(

I hope someone knows what to do and thanks for all suggestions.

/Martin

# lsb_release -a
No LSB modules are available.
Distributor ID:    Debian
Description:    Debian GNU/Linux 6.0.7 (squeeze)
Release:    6.0.7
Codename:    squeeze

# mysqld --verbose
131012 22:37:10 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
131012 22:37:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
131012 22:37:10  InnoDB: Initializing buffer pool, size = 8.0M
131012 22:37:10  InnoDB: Completed initialization of buffer pool
131012 22:37:10  InnoDB: Started; log sequence number 1 231236246
131012 22:37:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

My MySQL database directory looks a bit small ?

root@20dage:/var/lib/mysql/mysql# ls -al
total 44
drwx------ 2 mysql mysql 4096 Sep 11 23:38 .
drwx------ 8 mysql mysql 4096 Oct 12 22:51 ..
-rw-rw---- 1 mysql mysql   65 Aug 23 10:48 db.opt
-rw-rw---- 1 mysql mysql   35 Oct 11 03:25 general_log.CSM
-rw-rw---- 1 mysql mysql    0 Sep 11 23:38 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 Sep 11 23:38 general_log.frm
-rw-rw---- 1 mysql mysql   35 Oct 11 03:25 slow_log.CSM
-rw-rw---- 1 mysql mysql    0 Sep 11 23:38 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 Sep 11 23:38 slow_log.frm

3 Replies

If that's the entire contents of your /var/lib/mysql/mysql directory then you're missing a bunch of files. You can restore from a backup if you have one. Otherwise you can try running mysqlinstalldb to reinstall the mysql database tables.

Thanks.

Very strange - must be some kind of error in the updated debian packages.

So now I have reinstalled the mysql-server mysql-server-core package.

Currently I am importing my mysqldumps and recreating the different mysql-users.

Very unlikely a package update would do that. I would suspect unwelcome visitors and/or operator error.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct