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@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org