Mailinglist Archive: opensuse-factory (355 mails)

< Previous Next >
Re: [opensuse-factory] 15.2 beta update / mariadb problem
  • From: Per Jessen <per@xxxxxxxxxxxx>
  • Date: Mon, 16 Mar 2020 11:03:05 +0100
  • Message-id: <r4nisp$pg6$1@saturn.local.net>
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.



--
Per Jessen, Zürich (11.9°C)


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

< Previous Next >
Follow Ups
References