Ubuntu 11.10 -> 12.04 upgrade wipes all mysql databases and user info
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.5 (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned | ||
ubiquity (Ubuntu) |
Confirmed
|
High
|
Unassigned |
Bug Description
Package: mysql-server (and possibly other mysql-related packages)
Upgraded by using 12.04 LiveCD, 64-bit version. On completion of apparently successful upgrade, all user mysql databases are GONE from /var/lib/mysql/. All user account information seems to be gone, according to Workbench. Unable to log into PHPMyAdmin by any means. It looks like the upgrade completly deletes all previous mysql data and does a fresh install.
This is some seriously unfriendly behavior that, if not just a fluke, warrants immediate attention.
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server 5.5.22-0ubuntu1
ProcVersionSign
Uname: Linux 3.2.0-24-generic x86_64
NonfreeKernelMo
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Sat Apr 28 08:45:10 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
Logs.var.
Logs.var.
Apr 27 16:25:49 warren-laptop2 kernel: [ 21.905012] type=1400 audit(133556914
Apr 27 16:25:49 warren-laptop2 kernel: [ 21.962907] type=1400 audit(133556914
Apr 27 22:11:29 warren-laptop2 kernel: [ 8.041361] type=1400 audit(133558988
Apr 28 07:15:50 warren-laptop2 kernel: [ 2060.905423] type=1400 audit(133562255
Apr 28 08:30:10 warren-laptop2 kernel: [ 6514.017884] type=1400 audit(133562701
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
PackageArchitec
ProcEnviron:
TERM=xterm
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)
I believe this has been confirmed by another user, and by a third in a VM. Not sure if this is ubiquity or mysql.