http://bugzilla.novell.com/show_bug.cgi?id=586082 http://bugzilla.novell.com/show_bug.cgi?id=586082#c0 Summary: Upgrading mysql deletes /var/lib/mysql Classification: openSUSE Product: openSUSE 11.2 Version: Final Platform: Other OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: abockover@novell.com QAContact: qa@suse.de Found By: --- Blocker: Yes I ran into a horrific scenario today. I upgraded my Linode (which hosts my blog, at http://abock.org) from openSUSE 11.1 to 11.2 via zypper dup, which upgraded MySQL. To my horror, /var/lib/mysql was deleted (which contained my WordPress database, among others). It was replaced with the "default" MySQL state/databases: ib_logfile0 mysql mysql-bin.000003 mysql-bin.000006 ib_logfile1 mysql-bin.000001 mysql-bin.000004 mysql-bin.index ibdata1 mysql-bin.000002 mysql-bin.000005 test My databases were nowhere to be found. Gone. Deleted. To add insult to injury, apparently backups haven't happened (which were scheduled via my crontab) since May 2009. I have restored the databases from the last backup, and will have to rebuild content hopefully from Google's cache. (Of course now I am looking into what happened with the backups over the last 10 months...) I looked at the 11.2 spec file for MySQL and don't see anything obvious, so maybe this is a core bug in MySQL? It's horrific. I don't trust anything. I strongly suggest the openSUSE package create a backup of /var/lib/mysql and of [mysqld]/datadir as specified in /etc/my.cnf when uninstalling and installing. This is horrible. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.