CODEWITHSUNDEEP
mysql
NehaAgra
NehaAgra

Reputation: 39

Error importing MySQL database

Yesterday, I exported a MySQL database of fully functional website. Today I deleted the database and trying to import.

I don't understand this error because I am not a MySQL expert. But I have done the same (exporting, deleting and importing again) many times before and never face any problem.

I am getting below error:

Static analysis:

9 errors were found during analysis.

Unexpected character. (near ":" at position 664)
Unexpected character. (near ":" at position 732)
Unexpected character. (near ":" at position 735)
Unexpected character. (near ":" at position 755)
Unexpected character. (near ":" at position 758)
Unexpected character. (near "[" at position 765)
Unexpected character. (near "]" at position 767)
Unexpected character. (near "[" at position 788)
Unexpected character. (near "]" at position 790)

SQL query:

MySQL said: Documentation
#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 's comments. There you will have the option to edit or delete them.', 0, '1', '',' at line 2

The first few lines are....

-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: pdb14.websitehostingmart.com
-- Generation Time: Feb 25, 2017 at 06:00 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.5.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `135184_562`
--

-- --------------------------------------------------------

--
-- Table structure for table `wp_commentmeta`
--

Upvotes: 0

Views: 3196

Answers (1)

NehaAgra
NehaAgra

Reputation: 39

Export in xml format, make change (replace all or anything) and then import. As @DhruvSaxena pointed out that seialized data of .sql file could disrupt.

Upvotes: 2

Related Questions