Support

Akeeba Backup for WordPress

#23204 Restore sql problem

Posted in ‘Akeeba Backup for WordPress’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

WordPress version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by tampe125 on Wednesday, 02 September 2015 09:40 CDT

Schmu
SON Parse error: Unrecognized token '<'


Notice: Undefined variable: sql in /var/www/vhosts/abs.co.at/httpdocs/wordpress/installation/framework/database/driver/mysqli.php on line 597

{"percent":0,"restored":0,"total":0,"eta":0,"error":"
Datenbankfehler w\u00e4hrend der Verarbeitung auf Zeile 11<\/h2>\n
Datenbankserver Fehlerantwort:<\/p>\nErrNo #0<\/tt>\n
SQL=<\/pre>\n
Raw query text:<\/p>\n

CREATE TABLE `#__commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci<\/pre>\n","done":1}

tampe125
Akeeba Staff
Hello,

the problem is that the plugin you installed saved a lot of data inside a single row.
This means that when you try to restore it, the database can't handle so much data and dies.
Sadly there's nothing we can do: the developer of such plugin put you in a situation where you can't actually restore your data.
Even if you manually try to restore the SQL file using phpMyAdmin (or any other database management tool) you'll end up with the same error.
The only thing you can do is to ask your host to increase the value of max_allowed_packet inside MySQL configuration and hope they can do that.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!