Hi all, I need some guidance on how to create a proper bugreport. I'm running a server at home with Leap, which hosts among others an owncloud instance with mariadb as database backend. Since I was using a newer kernel because of XFS features anyway, yesterday I thought it would be a good idea to try updating to Leap 15.2 beta. I did take a fresh backup before doing this, which proved a good idea. After the update, the mariadb databases were broken. mysql root user was not able to access the database. Re-running "mysql_secure_installation" was not possible because of that. So I moved away /var/lib/mysql, rerun mysql_secure_installation and tried to restore the database dump with mysql -u root < /space3/backup/sda/mysqldump/2020-03-15.sql which choked on line 2009 2002 -- 2003 -- Table structure for table `user` 2004 -- 2005 2006 DROP TABLE IF EXISTS `user`; 2007 /*!40101 SET @saved_cs_client = @@character_set_client */; 2008 /*!40101 SET character_set_client = utf8 */; 2009 CREATE TABLE `user` ( 2010 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '', 2011 `User` char(80) COLLATE utf8_bin NOT NULL DEFAULT '', Because I needed the system up, the next try was "restore /var/lib/mysql from backup" which fortunately worked. My guess is that even though mariadb shows a post-upgrade message that you should backup /var/lib/mysql before restarting the database (which will perform an update), actually the RPM restarts the database and something went badly wrong at this step. As you might guess, I know nothing about mariadb and databases in general, so I'm type of lost on how to create a useful bugreport. I still have the (broken) contents of /var/lib/mysql that do not work. I also have a fairly complete backup of the system before the update, so if time permits, I might try to reproduce the issue in a virtual machine. So what information would the mariadb maintainer need from me in a good bugreport? Thanks, seife -- Stefan Seyfried "For a successful technology, reality must take precedence over public relations, for nature cannot be fooled." -- Richard Feynman -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org