Jump to content

phpMyAdmin export -> import errors


suntrop
 Share

Recommended Posts

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

Link to comment
Share on other sites

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 : mysqliDocumentation curlDocumentation mbstringDocumentation
  • Version PHP : 5.6.25
  • Version MySQL : 5.7.14
  • Version PHPMyAdmin :  4.6.4
  • Like 1
Link to comment
Share on other sites

:-) 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.

Link to comment
Share on other sites

 Share

×
×
  • Create New...