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