Restore a MySQL Database Backup (ERROR 1064 (42000))

perplex

• March 24, 2024 20:41

Hello. When using cPanel Backup Wizard to Restore mySQL databases, I get the following error:

{"type":"error","name":"restore_failed","data":{"file":"user1_db.sql","description":"The system failed to execute the database script with the following errors: ERROR 1064 (42000) at line 567: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(3) DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),\n  PRIMARY KEY (' at line 4\n"}}.

My corresponding DB Table:
DROP TABLE IF EXISTS `search`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `search` (
  `ID` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `searchvalue` varchar(250) CHARACTER SET utf8mb4 DEFAULT NULL,
  `created_at` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`ID`) USING BTREE,
  FULLTEXT KEY `searchvalue` (`searchvalue`)
) ENGINE=MyISAM AUTO_INCREMENT=5980 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

This means restore fails at this table! I've searched the net but cannot find a solution, any ideas?

 

• 

  Andrew

  • March 25, 2024 11:13

  You could try to import the database from PHPMyAdmin instead (it can be opened from cPanel) or if you have shell access then you can import it manually from command line using the "--force" option.

  Andrew N. - cPanel Plesk VMWare Certified Professional
  Do you need immediate assistance? 20 minutes response time!* Open a ticket
  EmergencySupport - Professional Server Management and One-time Services

  0
• 

  cPRex Jurassic Moderator

  • March 25, 2024 14:35

  It seems there is something wrong with the MySQL backup you are trying to restore if it is not letting you restore things normally.  A manual import on the command line like Andrew mentioned may provide more additional details about the problem.

  0

Please sign in to leave a comment.