phpMyAdmin export -> import errors

[suntrop]

Hi all

I have big troubles with my DB backups and phpMyAdmin. I can't manage to import a backup.

The phpMyAdmin export settings are left to the defaults. The error message I get:

#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 'INSERT INTO `caches` (`name`, `data`, `expires`) VALUES
('ModulesUninstalled.in' at line 11

When I delete the complete 'cache' section there are almost for all tables the same errors. (part of the dump attached)

I had this problem before and back then (couple months ago) I think I copied almost every table individually. I thought it was specific to that DB. But I can't do a dump/import of any of my PW installations.

MySQL: 5.6.27
PHP version: 7.0.11
phpMyAdmin: 4.5.5.1

Anybody knows that problem? Or what to do?

phpMyAdmin SQL Dump.sql

[flydev]

11 minutes ago, suntrop said:

Anybody knows that problem? Or what to do?

Just for informations - on my test installation, your dump is imported successfully.

• Apache/2.4.23 (Win64) PHP/5.6.25
• libmysql - mysqlnd 5.0.11-dev - 20120503
• Extension PHP : mysqli curl mbstring
• Version PHP : 5.6.25
• Version MySQL : 5.7.14
• Version PHPMyAdmin :  4.6.4

[suntrop]

That's a quick reply and help. Many thanks!

When I import the complete dump it stops at the first error. It seems the problem is caused by the import, not export. I'll ask my provider, perhaps they must install an update.