43 posts in this topic
Recently Browsing 0 members
No registered users viewing this page.
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.
PHP version: 7.0.11
Anybody knows that problem? Or what to do?
phpMyAdmin SQL Dump.sql
Is it possible to add check boxes in order to select multiple backup files and delete them all at once, rather than having to click each one, then Delete?
Also it would be helpful to make the Restore process more distinct from Deleting. I must have inadvertently clicked the wrong button once and restored a backup unintentionally, wiping out a day's work. My mistake of course. I obviously wasn't paying close enough attention.