[debian-mysql] Bug#617796: Bug#617796: mysql-server-5.1: Upgrade of debian stable silently ERASED my years old mysql database (no backup)

[Carlo Wood]

On Fri, 11 Mar 2011 15:01:28 +0100
Norbert Tretkowski <norbert at tretkowski.de> wrote:

> Am Freitag, den 11.03.2011, 14:48 +0100 schrieb Carlo Wood:
> > That didn't go *entirely* flawless, but within an hour I had
> > everything updated...
> 
> Could you please send me your /var/log/dpkg.log from the day when you
> upgraded your machine?

Hi, the upgrade was done on Feb 2, 2011. The logs
of that are attached as dpkg.log.2.gz

I also attached dpkg.log.1 and dpkg.log,
which is everything of what happened
after that.

The commands that I executed today, when I found
that my website wasn't working, I couldn't login
with myphpadmin and that mysqld wasn't running
were:

>history | grep mysql
   84  which mysqld
   87  apt-file search mysqld
   88  dpkg -l | grep mysql
   94  dpkg -l | grep mysql
   95  apt-get mysqld
   96  apt-file search mysqld
   97  apt-get install mysql-server-5.1 mysql-client-5.1
   99  mysqladmin version
  100  mysqladmin variables
  101  mysqladmin -h `hostname` version variables
  102  mysqladmin -h localhost version variables
  103  mysqladmin -h localhost --port=3306 version
  104  mysqladmin -h 192.168.2.2 version
  105  mysqladmin -h 127.0.0.1 version
  106  mysqladmin --protocol=SOCKET --socket=/tmp/mysql.sock version
  121  apt-get install mysql-server-5.1 mysql-client-5.1
  122  apt-get install --reinstall mysql-server-5.1
  124  mysqlreport
  126  mysqlshow
  127  mysqlcheck
  128  man mysqladmin
  129  mysqladmin password ********

after which I could login with myphpadmin and found
that all data was just gone.

-- 
Carlo Wood <carlo at alinoe.com>

PS The part that didn't go flawless about the upgrade was
that it seemed I couldn't reboot anymore. Later I discovered
that my video stopped given a signal... I fixed that by
booting an older kernel and black listing a kernel module.
This was unrelated to mysql thus. After this I could boot
the new kernel.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: dpkg.log
Type: text/x-log
Size: 16501 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20110311/9c1ead29/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dpkg.log.1
Type: application/octet-stream
Size: 5265 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20110311/9c1ead29/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dpkg.log.2.gz
Type: application/x-gzip
Size: 34702 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20110311/9c1ead29/attachment-0003.bin>