A very similar issue happened with 5.7.27-0ubuntu2 which needs to upgrade the 
database; in my setup, the datadir was not in the default folder /var/lib/mysql.
This means that the variable datadir describing a non-default location in 
/etc/mysql/mysql.cnf pointed by /etc/mysql/my.cnf has been overlooked.

A workaround is to:
- stop mysql.service
- rsync all data located in the folder pointed by datadir into /var/lib/mysql
- upgrade mysql-server-5.7
- stop mysql.service
- rsync all upgraded data back to its original non-default location
- restart mysql.service

Et voilĂ !

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1785693

Title:
  package mysql-server-5.7 5.7.23-0ubuntu0.18.04.1 failed to
  install/upgrade: installed mysql-server-5.7 package post-installation
  script subprocess returned error exit status 1

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1785693/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to