WordPress: Import MySQL database to MariaDB

Question

I want to import a MySQL dump (export from phpMyAdmin) on a new server with phpMyAdmin. The new server runs on MariaDB and the import skips everytime with an error message.

The MySQL version is: 5.5.52-log
The MariaDB version is: 10.1.21-MariaDB-1~trusty

The error message is #1064. From the docs:

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d

There are also a lot of notices about "Uninitialized string offsets".

Any ideas?

First 20 lines:

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 utf8 */;


CREATE TABLE IF NOT EXISTS `wp_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

show top 20 lines of your file. Which MySQL Version you have use to create the dump — Bernd Buffen
– Bernd Buffen, Commented Mar 16, 2017 at 15:02
Let's see the 1064 from running the code, not from the docs. — Rick James
– Rick James, Commented Mar 18, 2017 at 3:26

Bernd Buffen · Accepted Answer · 2017-03-16 15:11:54Z

1

It a little work. Remove all BAckticks in the Comments like this:

from

--
-- Dumping data for table `yourTable` 
--

to

--
-- Dumping data for table yourTable 
--

or remove the lines

answered Mar 16, 2017 at 15:11

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Cray Over a year ago

Is it only this? Is there a way to remove these lines on the export?

Bernd Buffen Over a year ago

linux? use this : $ grep -v "^--- " orgdump.sql >newdump.sql will remove all lines starting with "--- "

Cray Over a year ago

I exported without comments but the errors are still there

Bernd Buffen Over a year ago

can you refresh the top lines of your dumpfile.

Bernd Buffen Over a year ago

this looks god and also works on my server. if there are no secrets in it you can zip it and send it me by email and i will fix it for you

|

Cray · Accepted Answer · 2017-03-18 09:06:45Z

0

I could solve it by deleting the comments and the following line:

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

Thanks Bernd Buffen for the hints!

answered Mar 18, 2017 at 9:06

Cray

5,58313 gold badges94 silver badges196 bronze badges

Collectives™ on Stack Overflow

WordPress: Import MySQL database to MariaDB

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related