I think I found the reason for the backup error (Features)

by shian, Tuesday, September 08, 2020, 08:25 (1320 days ago) @ Auge

Thank you.

This is the entry in my last backup of my little forum, using the 'Backup' feature:

#
# mlf2_temp_infos
#
TRUNCATE TABLE mlf2_temp_infos;
INSERT INTO mlf2_temp_infos VALUES ('last_changes', '1598868462', '2020-08-31 13:07:42');
 


And this is the entry in my last backup of my little forum, using the server's cpanel:

--
-- Table structure for table `mlf2_temp_infos`
--
 
DROP TABLE IF EXISTS `mlf2_temp_infos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mlf2_temp_infos` (
  `name` VARCHAR(50) NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  `time` TIMESTAMP NULL DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `mlf2_temp_infos`
--
 
LOCK TABLES `mlf2_temp_infos` WRITE;
/*!40000 ALTER TABLE `mlf2_temp_infos` DISABLE KEYS */;
INSERT INTO `mlf2_temp_infos` (`name`, `value`, `time`) VALUES ('last_changes','1598868462','2020-08-31 10:07:42');
/*!40000 ALTER TABLE `mlf2_temp_infos` ENABLE KEYS */;
UNLOCK TABLES;
 


It looks OK. So I tried to restore again using my little forum 'Restore', and I got a new error! :-D :

Error!

    MySQL error: Column count doesn't match value count at row 1


it's getting interesting... BTW - The 'Restore' simply erased all entries in my Forum! :-|

Thank you, shian.


Complete thread:

 RSS Feed of thread