Upgrading MySQL 5.5 to MariaDB 10.0 on Ubuntu 12.04.3 LTS

I couldn’t find instructions for upgrading from MySQL 5.5 to MariaDB 10.0 on Ubuntu 12.04.3 LTS. Fortunately, MariaDB and Ubuntu didn’t let me down, and provided a smooth installation process. Here’s a log of my console session in case it helps anyone else out there!

Excellent resources used:

root@buttercup:/home/rich# cd backups/
root@buttercup:/home/rich/backups# ls
2013-10-01 19-01-27.tar.gz  2014-04-06 4-00-01.tar.gz  2014-05-11 4-00-01.tar.gz  2014-06-15 4-00-01.tar.gz  2014-08-03 4-00-01.tar.gz  2014-09-07 4-00-01.tar.gz  mon.tar.gz
2013-11-03 4-00-01.tar.gz  2014-04-13 4-00-01.tar.gz  2014-05-18 4-00-01.tar.gz  2014-06-22 4-00-01.tar.gz  2014-08-10 4-00-01.tar.gz  2014-09-14 4-00-01.tar.gz  sat.tar.gz
2013-12-01 4-00-01.tar.gz  2014-04-20 4-00-01.tar.gz  2014-05-25 4-00-01.tar.gz  2014-07-13 4-00-01.tar.gz  2014-08-17 4-00-01.tar.gz  2014-09-21 4-00-01.tar.gz  thu.tar.gz
2014-02-02 4-00-01.tar.gz  2014-04-27 4-00-01.tar.gz  2014-06-01 4-00-01.tar.gz  2014-07-20 4-00-01.tar.gz  2014-08-24 4-00-01.tar.gz  2014-09-28 4-00-01.tar.gz  tue.tar.gz
2014-03-02 4-00-01.tar.gz  2014-05-04 4-00-01.tar.gz  2014-06-08 4-00-01.tar.gz  2014-07-27 4-00-01.tar.gz  2014-08-31 4-00-01.tar.gz  fri.tar.gz                wed.tar.gz
root@buttercup:/home/rich/backups# cd ..
root@buttercup:/home/rich/scripts# cp -r /etc/mysql /etc/mysql-backup-10-3-14
root@buttercup:/home/rich/scripts# ls /etc/mysql-backup-10-3-14/
conf.d  debian.cnf  debian-start  my.cnf
root@buttercup:/home/rich/scripts# ls /etc/mysql
conf.d  debian.cnf  debian-start  my.cnf
root@buttercup:/home/rich/scripts# service mysql stop
mysql stop/waiting
root@buttercup:/home/rich/scripts# apt-get remove mysql-common mysql-server-5.5 mysql-server-core-5.5 mysql-client-5.5 mysql-client-core-5.5
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  node-node-uuid libgsasl7 libv8- libax25 m4 libhtml-template-perl procmail sendmail-cf sendmail-base libssl-dev libssl-doc zlib1g-dev libntlm0 libev4 libv8-dev
  libc-ares2 thunderbird-globalmenu libdb4.8 libev-dev libc-ares-dev openbsd-inetd
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
  libdbd-mysql-perl libmailutils2 libmysqlclient18 mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 0 newly installed, 9 to remove and 377 not upgraded.
After this operation, 97.3 MB disk space will be freed.
Do you want to continue [Y/n]? Y
(Reading database ... 179727 files and directories currently installed.)
Removing mysql-server ...
Removing mysql-server-5.5 ...
Removing mysql-client-5.5 ...
Removing libdbd-mysql-perl ...
Removing libmailutils2 ...
Removing libmysqlclient18 ...
Removing mysql-client-core-5.5 ...
Removing mysql-common ...
Removing mysql-server-core-5.5 ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
root@buttercup:/home/rich/scripts# apt-get autoremove
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  libax25 libc-ares-dev libc-ares2 libdb4.8 libdbi-perl libev-dev libev4 libgsasl7 libhtml-template-perl libnet-daemon-perl libntlm0 libplrpc-perl libssl-dev libssl-doc
  libterm-readkey-perl libv8- libv8-dev m4 node-node-uuid openbsd-inetd procmail sendmail-base sendmail-cf thunderbird-globalmenu zlib1g-dev
0 upgraded, 0 newly installed, 25 to remove and 371 not upgraded.
After this operation, 22.1 MB disk space will be freed.
Do you want to continue [Y/n]? Y
(Reading database ... 179412 files and directories currently installed.)
Removing libax25 ...
Removing libc-ares-dev ...
Removing libc-ares2 ...
Removing libdb4.8 ...
Removing libdbi-perl ...
Removing libev-dev ...
Removing libev4 ...
Removing libgsasl7 ...
Removing libhtml-template-perl ...
Removing libplrpc-perl ...
Removing libnet-daemon-perl ...
Removing libntlm0 ...
Removing libssl-dev ...
Removing libssl-doc ...
Removing libterm-readkey-perl ...
Removing libv8-dev ...
Removing libv8- ...
Removing sendmail-cf ...
Removing sendmail-base ...
Removing m4 ...
Removing node-node-uuid ...
Removing openbsd-inetd ...
 * Stopping internet superserver inetd                                                                                                                                     [ OK ] 
Removing procmail ...
Removing thunderbird-globalmenu ...
Removing zlib1g-dev ...
Processing triggers for man-db ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
Processing triggers for install-info ...
Processing triggers for ureadahead ...
root@buttercup:/home/rich/scripts# cd
root@buttercup:~# sudo apt-get install python-software-properties
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be upgraded:
1 upgraded, 0 newly installed, 0 to remove and 370 not upgraded.
Need to get 23.5 kB of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main python-software-properties all [23.5 kB]
Fetched 23.5 kB in 0s (104 kB/s)                      
(Reading database ... 177156 files and directories currently installed.)
Preparing to replace python-software-properties (using .../python-software-properties_0.82.7.7_all.deb) ...
Unpacking replacement python-software-properties ...
Processing triggers for man-db ...
Setting up python-software-properties ( ...
root@buttercup:~# sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /tmp/tmp.a1Ik7tcUIy --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com
gpg: key 1BB943DB: public key "MariaDB Package Signing Key " imported
gpg: no ultimately trusted keys found
gpg: Total number processed: 1
gpg:               imported: 1
root@buttercup:~# sudo add-apt-repository 'deb http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu precise main'
root@buttercup:~# sudo apt-get update
Hit http://dl.google.com stable Release.gpg
Hit http://apt.newrelic.com newrelic Release.gpg                                                                                                                                 
Hit http://dl.google.com stable Release                                                                                                                                          
Hit http://us.archive.ubuntu.com precise Release.gpg                                                                                                                             
Get:1 http://us.archive.ubuntu.com precise-updates Release.gpg [198 B]                                                                                                           
Hit http://us.archive.ubuntu.com precise-backports Release.gpg                                                                                                                   
Get:2 http://security.ubuntu.com precise-security Release.gpg [198 B]                                                                                              
Hit http://apt.newrelic.com newrelic Release                                                                                                                             
Get:3 http://mirrors.syringanetworks.net precise Release.gpg [198 B]                                                                                          
Hit http://dl.google.com stable/main amd64 Packages                                                                                                                 
Hit http://us.archive.ubuntu.com precise Release                                                                                                                    
Get:4 http://us.archive.ubuntu.com precise-updates Release [98.7 kB]                                                                                                             
Get:5 http://security.ubuntu.com precise-security Release [50.7 kB]                                                                                                              
Hit http://apt.newrelic.com newrelic/non-free amd64 Packages                                                                                                                     
Hit http://dl.google.com stable/main i386 Packages                                                                                                                              
Hit http://extras.ubuntu.com precise Release.gpg                                                                                                                                
Get:6 http://mirrors.syringanetworks.net precise Release [2,261 B]                                                                                                              
Ign http://dl.google.com stable/main TranslationIndex                                                                                                                            
Hit http://ppa.launchpad.net precise Release.gpg                                                                                                                                 
Hit http://apt.newrelic.com newrelic/non-free i386 Packages                                                                                                                      
Ign http://apt.newrelic.com newrelic/non-free TranslationIndex                                                                                                                   
Get:7 http://mirrors.syringanetworks.net precise/main Sources [997 B]                                                                                                            
Hit http://extras.ubuntu.com precise Release                                                                                                                                     
Get:8 http://mirrors.syringanetworks.net precise/main amd64 Packages [5,718 B]                                                                                                   
Get:9 http://mirrors.syringanetworks.net precise/main i386 Packages [5,712 B]                                                                                                    
Hit http://ppa.launchpad.net precise Release                                                                                                                                     
Ign http://mirrors.syringanetworks.net precise/main TranslationIndex                                                                                
Get:10 http://security.ubuntu.com precise-security/main Sources [111 kB]                                                                         
Hit http://us.archive.ubuntu.com precise-backports Release                                                                                                                      
Hit http://extras.ubuntu.com precise/main Sources                                                                                                                                
Hit http://ppa.launchpad.net precise/main Sources                                                                                                                      
Hit http://us.archive.ubuntu.com precise/main Sources                                                                                            
Hit http://us.archive.ubuntu.com precise/restricted Sources                                                                                                            
Hit http://us.archive.ubuntu.com precise/universe Sources                                                                                                              
Hit http://us.archive.ubuntu.com precise/multiverse Sources                                                                                                            
Hit http://us.archive.ubuntu.com precise/main amd64 Packages                                                                                                           
Hit http://us.archive.ubuntu.com precise/restricted amd64 Packages                                                                                                     
Hit http://us.archive.ubuntu.com precise/universe amd64 Packages                                                                                 
Hit http://us.archive.ubuntu.com precise/multiverse amd64 Packages                                                                                                     
Hit http://us.archive.ubuntu.com precise/main i386 Packages                                                                                                            
Hit http://us.archive.ubuntu.com precise/restricted i386 Packages                                                                                
Hit http://us.archive.ubuntu.com precise/universe i386 Packages                                                                                  
Hit http://us.archive.ubuntu.com precise/multiverse i386 Packages                                                                                                      
Hit http://us.archive.ubuntu.com precise/main TranslationIndex                                                                                                         
Hit http://us.archive.ubuntu.com precise/multiverse TranslationIndex                                                                                                   
Hit http://us.archive.ubuntu.com precise/restricted TranslationIndex                                                                                                   
Hit http://extras.ubuntu.com precise/main amd64 Packages                                                                                                               
Ign http://dl.google.com stable/main Translation-en_US                                                                                                                 
Hit http://extras.ubuntu.com precise/main i386 Packages                                                                                                                
Ign http://extras.ubuntu.com precise/main TranslationIndex                                                                                       
Hit http://ppa.launchpad.net precise/main amd64 Packages                                                                                         
Hit http://ppa.launchpad.net precise/main i386 Packages                                                                                                                
Hit http://ppa.launchpad.net precise/main TranslationIndex                                                                                                             
Ign http://dl.google.com stable/main Translation-en                                                                                                                    
Hit http://us.archive.ubuntu.com precise/universe TranslationIndex                                                                               
Get:11 http://us.archive.ubuntu.com precise-updates/main Sources [479 kB]                                                                        
Ign http://apt.newrelic.com newrelic/non-free Translation-en_US                                                                                                        
Hit http://ppa.launchpad.net precise/main Translation-en                                                                                                               
Ign http://apt.newrelic.com newrelic/non-free Translation-en                                                                                     
Get:12 http://security.ubuntu.com precise-security/restricted Sources [2,494 B]                                            
Get:13 http://security.ubuntu.com precise-security/universe Sources [32.7 kB]                                    
Get:14 http://security.ubuntu.com precise-security/multiverse Sources [1,785 B]                                                        
Get:15 http://security.ubuntu.com precise-security/main amd64 Packages [426 kB]                                
Ign http://mirrors.syringanetworks.net precise/main Translation-en_US                                                                
Ign http://mirrors.syringanetworks.net precise/main Translation-en                                            
Get:16 http://us.archive.ubuntu.com precise-updates/restricted Sources [8,056 B]         
Get:17 http://us.archive.ubuntu.com precise-updates/universe Sources [110 kB]                                    
Get:18 http://us.archive.ubuntu.com precise-updates/multiverse Sources [8,886 B]                                
Get:19 http://us.archive.ubuntu.com precise-updates/main amd64 Packages [837 kB]                              
Get:20 http://security.ubuntu.com precise-security/restricted amd64 Packages [4,627 B]                           
Get:21 http://security.ubuntu.com precise-security/universe amd64 Packages [98.1 kB]                               
Get:22 http://security.ubuntu.com precise-security/multiverse amd64 Packages [2,447 B]                             
Get:23 http://security.ubuntu.com precise-security/main i386 Packages [458 kB]                                      
Ign http://extras.ubuntu.com precise/main Translation-en_US                                                      
Get:24 http://security.ubuntu.com precise-security/restricted i386 Packages [4,620 B]    
Get:25 http://security.ubuntu.com precise-security/universe i386 Packages [104 kB]                             
Get:26 http://us.archive.ubuntu.com precise-updates/restricted amd64 Packages [13.7 kB]                        
Get:27 http://us.archive.ubuntu.com precise-updates/universe amd64 Packages [248 kB]                            
Ign http://extras.ubuntu.com precise/main Translation-en                                                        
Get:28 http://security.ubuntu.com precise-security/multiverse i386 Packages [2,638 B]                           
Hit http://security.ubuntu.com precise-security/main TranslationIndex                         
Hit http://security.ubuntu.com precise-security/multiverse TranslationIndex
Hit http://security.ubuntu.com precise-security/restricted TranslationIndex           
Hit http://security.ubuntu.com precise-security/universe TranslationIndex             
Get:29 http://us.archive.ubuntu.com precise-updates/multiverse amd64 Packages [15.3 kB]
Get:30 http://us.archive.ubuntu.com precise-updates/main i386 Packages [868 kB]     
Hit http://security.ubuntu.com precise-security/main Translation-en              
Hit http://security.ubuntu.com precise-security/multiverse Translation-en        
Hit http://security.ubuntu.com precise-security/restricted Translation-en
Hit http://security.ubuntu.com precise-security/universe Translation-en          
Get:31 http://us.archive.ubuntu.com precise-updates/restricted i386 Packages [13.7 kB]
Get:32 http://us.archive.ubuntu.com precise-updates/universe i386 Packages [255 kB]
Get:33 http://us.archive.ubuntu.com precise-updates/multiverse i386 Packages [15.5 kB]
Hit http://us.archive.ubuntu.com precise-updates/main TranslationIndex
Hit http://us.archive.ubuntu.com precise-updates/multiverse TranslationIndex
Hit http://us.archive.ubuntu.com precise-updates/restricted TranslationIndex
Hit http://us.archive.ubuntu.com precise-updates/universe TranslationIndex
Hit http://us.archive.ubuntu.com precise-backports/main Sources
Hit http://us.archive.ubuntu.com precise-backports/restricted Sources
Hit http://us.archive.ubuntu.com precise-backports/universe Sources
Hit http://us.archive.ubuntu.com precise-backports/multiverse Sources
Hit http://us.archive.ubuntu.com precise-backports/main amd64 Packages
Hit http://us.archive.ubuntu.com precise-backports/restricted amd64 Packages
Hit http://us.archive.ubuntu.com precise-backports/universe amd64 Packages
Hit http://us.archive.ubuntu.com precise-backports/multiverse amd64 Packages
Hit http://us.archive.ubuntu.com precise-backports/main i386 Packages
Hit http://us.archive.ubuntu.com precise-backports/restricted i386 Packages
Hit http://us.archive.ubuntu.com precise-backports/universe i386 Packages
Hit http://us.archive.ubuntu.com precise-backports/multiverse i386 Packages
Hit http://us.archive.ubuntu.com precise-backports/main TranslationIndex
Hit http://us.archive.ubuntu.com precise-backports/multiverse TranslationIndex
Hit http://us.archive.ubuntu.com precise-backports/restricted TranslationIndex
Hit http://us.archive.ubuntu.com precise-backports/universe TranslationIndex
Hit http://us.archive.ubuntu.com precise/main Translation-en
Hit http://us.archive.ubuntu.com precise/multiverse Translation-en
Hit http://us.archive.ubuntu.com precise/restricted Translation-en
Hit http://us.archive.ubuntu.com precise/universe Translation-en
Hit http://us.archive.ubuntu.com precise-updates/main Translation-en
Hit http://us.archive.ubuntu.com precise-updates/multiverse Translation-en
Hit http://us.archive.ubuntu.com precise-updates/restricted Translation-en
Hit http://us.archive.ubuntu.com precise-updates/universe Translation-en
Hit http://us.archive.ubuntu.com precise-backports/main Translation-en
Hit http://us.archive.ubuntu.com precise-backports/multiverse Translation-en
Hit http://us.archive.ubuntu.com precise-backports/restricted Translation-en
Hit http://us.archive.ubuntu.com precise-backports/universe Translation-en
Fetched 4,284 kB in 3s (1,380 kB/s)
Reading package lists... Done
root@buttercup:~# sudo apt-get install mariadb-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmariadbclient18 libmysqlclient18 libnet-daemon-perl libplrpc-perl libreadline5 mariadb-client-10.0
  mariadb-client-core-10.0 mariadb-common mariadb-server-10.0 mariadb-server-core-10.0 mysql-common
Suggested packages:
  libipc-sharedcache-perl libterm-readkey-perl tinyca mailx mariadb-test
The following NEW packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl libmariadbclient18 libmysqlclient18 libnet-daemon-perl libplrpc-perl libreadline5 mariadb-client-10.0
  mariadb-client-core-10.0 mariadb-common mariadb-server mariadb-server-10.0 mariadb-server-core-10.0 mysql-common
0 upgraded, 16 newly installed, 0 to remove and 370 not upgraded.
Need to get 36.3 MB of archives.
After this operation, 125 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://us.archive.ubuntu.com/ubuntu/ precise/main libaio1 amd64 0.3.109-2ubuntu1 [6,396 B]
Get:2 http://us.archive.ubuntu.com/ubuntu/ precise/main libreadline5 amd64 5.2-11 [128 kB]
Get:3 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mysql-common all 10.0.14+maria-1~precise [8,828 B]
Get:4 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-common all 10.0.14+maria-1~precise [3,300 B]
Get:5 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main libmariadbclient18 amd64 10.0.14+maria-1~precise [919 kB]
Get:6 http://us.archive.ubuntu.com/ubuntu/ precise/main libnet-daemon-perl all 0.48-1 [43.1 kB]
Get:7 http://us.archive.ubuntu.com/ubuntu/ precise/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get:8 http://us.archive.ubuntu.com/ubuntu/ precise/main libdbi-perl amd64 1.616-1build2 [849 kB]
Get:9 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main libmysqlclient18 amd64 10.0.14+maria-1~precise [2,958 B]
Get:10 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-client-core-10.0 amd64 10.0.14+maria-1~precise [1,820 kB]
Get:11 http://us.archive.ubuntu.com/ubuntu/ precise/main libdbd-mysql-perl amd64 4.020-1build2 [106 kB]
Get:12 http://us.archive.ubuntu.com/ubuntu/ precise/main libhtml-template-perl all 2.10-1 [65.0 kB]
Get:13 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-client-10.0 amd64 10.0.14+maria-1~precise [5,440 kB]
Get:14 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-server-core-10.0 amd64 10.0.14+maria-1~precise [5,636 kB]
Get:15 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-server-10.0 amd64 10.0.14+maria-1~precise [21.2 MB]                                     
Get:16 http://mirrors.syringanetworks.net/mariadb/repo/10.0/ubuntu/ precise/main mariadb-server all 10.0.14+maria-1~precise [2,998 B]                                            
Fetched 36.3 MB in 16s (2,182 kB/s)                                                                                                                                              
Preconfiguring packages ...
Selecting previously unselected package libaio1.
(Reading database ... 177156 files and directories currently installed.)
Unpacking libaio1 (from .../libaio1_0.3.109-2ubuntu1_amd64.deb) ...
Selecting previously unselected package libreadline5.
Unpacking libreadline5 (from .../libreadline5_5.2-11_amd64.deb) ...
Selecting previously unselected package mysql-common.
Unpacking mysql-common (from .../mysql-common_10.0.14+maria-1~precise_all.deb) ...
Selecting previously unselected package mariadb-common.
Unpacking mariadb-common (from .../mariadb-common_10.0.14+maria-1~precise_all.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ...
Selecting previously unselected package libmariadbclient18.
Unpacking libmariadbclient18 (from .../libmariadbclient18_10.0.14+maria-1~precise_amd64.deb) ...
Selecting previously unselected package libmysqlclient18.
Unpacking libmysqlclient18 (from .../libmysqlclient18_10.0.14+maria-1~precise_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ...
Selecting previously unselected package mariadb-client-core-10.0.
Unpacking mariadb-client-core-10.0 (from .../mariadb-client-core-10.0_10.0.14+maria-1~precise_amd64.deb) ...
Selecting previously unselected package mariadb-client-10.0.
Unpacking mariadb-client-10.0 (from .../mariadb-client-10.0_10.0.14+maria-1~precise_amd64.deb) ...
Selecting previously unselected package mariadb-server-core-10.0.
Unpacking mariadb-server-core-10.0 (from .../mariadb-server-core-10.0_10.0.14+maria-1~precise_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (10.0.14+maria-1~precise) ...

Configuration file `/etc/mysql/my.cnf'
 ==> Modified (by you or by a script) since installation.
 ==> Package distributor has shipped an updated version.
   What would you like to do about it ?  Your options are:
    Y or I  : install the package maintainer's version
    N or O  : keep your currently-installed version
      D     : show the differences between the versions
      Z     : start a shell to examine the situation
 The default action is to keep your current version.
*** my.cnf (Y/I/N/O/D/Z) [default=N] ? Y
Installing new version of config file /etc/mysql/my.cnf ...
Setting up mariadb-common (10.0.14+maria-1~precise) ...
Selecting previously unselected package mariadb-server-10.0.
(Reading database ... 177540 files and directories currently installed.)
Unpacking mariadb-server-10.0 (from .../mariadb-server-10.0_10.0.14+maria-1~precise_amd64.deb) ...
Selecting previously unselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.10-1_all.deb) ...
Selecting previously unselected package mariadb-server.
Unpacking mariadb-server (from .../mariadb-server_10.0.14+maria-1~precise_all.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up libaio1 (0.3.109-2ubuntu1) ...
Setting up libreadline5 (5.2-11) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.616-1build2) ...
Setting up libhtml-template-perl (2.10-1) ...
Setting up libmysqlclient18 (10.0.14+maria-1~precise) ...
Setting up libdbd-mysql-perl (4.020-1build2) ...
Setting up libmariadbclient18 (10.0.14+maria-1~precise) ...
Setting up mariadb-client-core-10.0 (10.0.14+maria-1~precise) ...
Setting up mariadb-client-10.0 (10.0.14+maria-1~precise) ...
Setting up mariadb-server-core-10.0 (10.0.14+maria-1~precise) ...
Setting up mariadb-server-10.0 (10.0.14+maria-1~precise) ...
Installing new version of config file /etc/logrotate.d/mysql-server ...
Installing new version of config file /etc/mysql/debian-start ...
Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ...
 * Stopping MariaDB database server mysqld                                                                                                                                 [ OK ] 
141003 18:06:32 [Note] InnoDB: Using mutexes to ref count buffer pool pages
141003 18:06:32 [Note] InnoDB: The InnoDB memory heap is disabled
141003 18:06:32 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
141003 18:06:32 [Note] InnoDB: Memory barrier is not used
141003 18:06:32 [Note] InnoDB: Compressed tables use zlib
141003 18:06:32 [Note] InnoDB: Using Linux native AIO
141003 18:06:32 [Note] InnoDB: Using CPU crc32 instructions
141003 18:06:32 [Note] InnoDB: Initializing buffer pool, size = 256.0M
141003 18:06:32 [Note] InnoDB: Completed initialization of buffer pool
141003 18:06:32 [Note] InnoDB: Highest supported file format is Barracuda.
141003 18:06:33 [Note] InnoDB: 128 rollback segment(s) are active.
141003 18:06:33 [Note] InnoDB: Waiting for purge to start
141003 18:06:33 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 72018642640
141003 18:06:33 [Note] Plugin 'FEEDBACK' is disabled.
141003 18:06:33 [Note] InnoDB: FTS optimize thread exiting.
141003 18:06:33 [Note] InnoDB: Starting shutdown...
141003 18:06:35 [Note] InnoDB: Shutdown completed; log sequence number 72018647790
 * Starting MariaDB database server mysqld                                                                                                                                 [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
Setting up mariadb-server (10.0.14+maria-1~precise) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
root@buttercup:~# service mysql start
mysql start/running, process 12179
root@buttercup:~# mysql -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.0.14-MariaDB-1~precise-log mariadb.org binary distribution

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
| Database           |
| information_schema |
| mysql              |
| performance_schema |
| xxx_backend     |
| xxx_yy          |
| test               |
6 rows in set (0.00 sec)

MariaDB [(none)]> quit
root@buttercup:~# mysql_upgrade -p
Enter password: 
Phase 1/4: Checking mysql database
Processing databases
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Phase 2/4: Running 'mysql_fix_privilege_tables'...
Phase 3/4: Fixing table and database names
Phase 4/4: Checking and upgrading tables
Processing databases
xxx_backend.addon                               OK
xxx_backend.addon_package                       OK

... (LOTS more output removed) ...