MySQL Forums
Forum List  »  Newbie

Syntax error?
Posted by: Charlie Savage
Date: May 13, 2021 09:28AM

Hello - I am trying to import a Wordpress .sql database for a website I have moved to a new account. I backed it up but sadly did not do the one click migration. I've encountered an issue that is flummoxing me; does anyone have a suggestion, please? Below I've pasted 1) an error message about part of the sql file I get when I try to import the sql database, and 2) the relevant part of the sql file, I don't immediately see in the 5000 page manual for the corresponding manual what I should be changing. Help much appreciated!

1) ERROR MESSAGE:

ErrorSQL query:  -- <?php exit; __halt_compiler(); // Protect the file from being visited via web
-- Orion backup format
-- Generated at: 2021-01-30T12:01:54+00:00 by ClonerDBAdapter; PHP v7.2.25
-- Selected via: SELECT `id`, `option_name`, `option_value` FROM `wp_wsal_options`;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said:  #1064 - 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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COL' at line 4

2) THAT PART OF THE SQL FILE

-- <?php exit; __halt_compiler(); // Protect the file from being visited via web
-- Orion backup format
-- Generated at: 2020-05-06T11:03:30+00:00 by ClonerPDOConn; PHP v7.2.25
-- Selected via: SELECT `meta_id`, `comment_id`, `meta_key`, `meta_value` FROM `wp_commentmeta`;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Options: ReplyQuote


Subject
Written By
Posted
Syntax error?
May 13, 2021 09:28AM
May 13, 2021 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.