Mailinglist Archive: opensuse-factory (355 mails)

< Previous Next >
Re: [opensuse-factory] 15.2 beta update / mariadb problem
  • From: per@xxxxxxxxxxxx
  • Date: Tue, 17 Mar 2020 12:28:29 +0100
  • Message-id: <r4qc8t$83g$1@saturn.local.net>
Stefan Seyfried wrote:

Am 16.03.20 um 11:03 schrieb Per Jessen:
Stefan Seyfried wrote:

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 '',

Hi seife

'choked' exactly how - ie. which error message? I would say failing
on a "create table" is quite unusual.

It was a mysql error with a number, i googled for it and it seems to
mean "table already exists" or such.

FWIW, I have reproduced your problem (with the export you provided in
the bugreport). It appears that the mysql.user table is not being
dropped despite 'DROP TABLE IF EXISTS `user`'.

The issue is that 'user' in this version (10.4.12) of mariadb is not a
table, but a view. In Leap 15.1, version 10.2.25, it was a table.



--
Per Jessen, Zürich (16.7°C)
Member, openSUSE Heroes

--
To unsubscribe, e-mail: opensuse-factory+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >