Bug#617796: [debian-mysql] Bug#617796: mysql-server-5.1: Upgrade of debian, stable silently ERASED my years old mysql database (no backup)
maybe this bug should rather be closed. The submitter purged mysql-server and that did what it's supposed to do... I don't agree. Purging vi also doesn't remove all files you ever edited... I assume the debconf question is asked at install time, which could be years before the purge is done. IMO it's way easier and safer to drop the question and to drop the removal of the databases themselves. Olaf -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#617796: [debian-mysql] Bug#617796: mysql-server-5.1: Upgrade of debian stable silently ERASED my years old mysql database (no backup)
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? Regards Norbert -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#617796: [debian-mysql] Bug#617796: mysql-server-5.1: Upgrade of debian stable silently ERASED my years old mysql database (no backup)
Am Freitag, den 11.03.2011, 16:22 +0100 schrieb Carlo Wood: Hi, the upgrade was done on Feb 2, 2011. The logs of that are attached as dpkg.log.2.gz If you mean Feb 7, then mysql-server-5.0 was purged at that day: 2011-02-07 21:03:29 purge mysql-server-5.0 5.0.51a-24+lenny4 5.0.51a-24+lenny4 According to your debconf settings, you will see a question asking you if you want to purge the databases as well, but it only removes the database files if you explicitly tell debconf to do so, the default is to keep the database files. I just purged the mysql-server* packages from one of my systems, but after that it still has the /var/lib/mysql/ directory containing the databases. Regards Norbert -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#617796: [debian-mysql] Bug#617796: mysql-server-5.1: Upgrade of debian stable silently ERASED my years old mysql database (no backup)
On Fri, 11 Mar 2011 16:55:51 +0100 Norbert Tretkowski norb...@tretkowski.de wrote: Well... I guess I did that -- at the moment not thinking / remembering what I needed a sql database for... But I feel still pissed that it didn't warn me a little bit more clear before actually deleting database files :/... I mean... It should be possible to ask for confirmation in a way that I would have hesitated right? Like when you try to format a harddisk: *** ALL DATA WILL BE LOST *** kind of thing? Nevertheless, you say you just purged a package and the database is still there? It definitely isn't here :/ So, when did it get deleted? And by what? If reinstalling the package simply overwrote the old database then that is bug: it should never do that. Also, I looked with ext3grep if I could see anything (although I wasn't, and still am, not even sure what file to look for) and I could find any trace of anything deleted in /var/lib/mysql. Am Freitag, den 11.03.2011, 16:22 +0100 schrieb Carlo Wood: Hi, the upgrade was done on Feb 2, 2011. The logs of that are attached as dpkg.log.2.gz If you mean Feb 7, then mysql-server-5.0 was purged at that day: 2011-02-07 21:03:29 purge mysql-server-5.0 5.0.51a-24+lenny4 5.0.51a-24+lenny4 According to your debconf settings, you will see a question asking you if you want to purge the databases as well, but it only removes the database files if you explicitly tell debconf to do so, the default is to keep the database files. I just purged the mysql-server* packages from one of my systems, but after that it still has the /var/lib/mysql/ directory containing the databases. Regards Norbert -- Carlo Wood ca...@alinoe.com -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#617796: [debian-mysql] Bug#617796: mysql-server-5.1: Upgrade of debian stable silently ERASED my years old mysql database (no backup)
Am Freitag, den 11.03.2011, 17:28 +0100 schrieb Carlo Wood: Nevertheless, you say you just purged a package and the database is still there? It definitely isn't here :/ So, when did it get deleted? And by what? I don't know. If reinstalling the package simply overwrote the old database then that is bug: it should never do that. The database files are still there after reinstalling the mysql-server package. Purging and reinstalling mysql-server doesn't overwrite your existing databases: mysql create database bug617796; Query OK, 1 row affected (0.00 sec) mysql show databases; ++ | Database | ++ | information_schema | | bug617796 | | mysql | ++ 3 rows in set (0.00 sec) # dpkg --purge mysql-server-core-5.1 mysql-server-5.1 (Lese Datenbank ... 35080 Dateien und Verzeichnisse sind derzeit installiert.) Entfernen von mysql-server-5.1 ... Stopping MySQL database server: mysqld. Löschen der Konfigurationsdateien von mysql-server-5.1 ... Entfernen von mysql-server-core-5.1 ... Trigger für man-db werden verarbeitet ... v80178.ddc-ipx.de:~# apt-get --no-install-recommends install mysql-server-5.1 Paketlisten werden gelesen... Fertig Abhängigkeitsbaum wird aufgebaut Statusinformationen werden eingelesen... Fertig Die folgenden zusätzlichen Pakete werden installiert: mysql-server-core-5.1 Vorgeschlagene Pakete: tinyca Empfohlene Pakete: libhtml-template-perl Die folgenden NEUEN Pakete werden installiert: mysql-server-5.1 mysql-server-core-5.1 0 aktualisiert, 2 neu installiert, 0 zu entfernen und 0 nicht aktualisiert. Es müssen noch 0 B von 10,9 MB an Archiven heruntergeladen werden. Nach dieser Operation werden 26,7 MB Plattenplatz zusätzlich benutzt. Möchten Sie fortfahren [J/n]? Vorkonfiguration der Pakete ... Vormals abgewähltes Paket mysql-server-core-5.1 wird gewählt. (Lese Datenbank ... 34914 Dateien und Verzeichnisse sind derzeit installiert.) Entpacken von mysql-server-core-5.1 (aus .../mysql-server-core-5.1_5.1.56-1_amd64.deb) ... Vormals abgewähltes Paket mysql-server-5.1 wird gewählt. Entpacken von mysql-server-5.1 (aus .../mysql-server-5.1_5.1.56-1_amd64.deb) ... Trigger für man-db werden verarbeitet ... mysql-server-core-5.1 (5.1.56-1) wird eingerichtet ... mysql-server-5.1 (5.1.56-1) wird eingerichtet ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. # mysql -p -e show databases; Enter password: ++ | Database | ++ | information_schema | | bug617796 | | mysql | ++ Regards Norbert -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org