Mailinglist Archive: opensuse-factory (355 mails)

< Previous Next >
Re: [opensuse-factory] 15.2 beta update / mariadb problem
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.
Unfortunately, I have no exact records of the problem, and back then was very
focused on getting it to work again.

But this error should be easily reproducible for me on an fresh 15.2
installation when trying to restore this backup, so
I can probably relatively easy file a bug for that.

Best regards,

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

< Previous Next >
Follow Ups