PhpMyAdmin - maxDynRespSize Error
Posted by: disturbed (---.165.22.74.dynamic.ttnet.com.tr)
Date: November 13, 2021 12:09PM

I want to set up my live website with old backups in localhost. However, when I try to import the database into PhpMyAdmin, I get the error maxDynRespSize. What should I do?

The error is exactly like this:
#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 'maxDynRespSize' located in the tuning section of the server configuration, and l' at line 2

Options: ReplyQuote
Re: PhpMyAdmin - maxDynRespSize Error
Posted by: Otomatic (Moderator)
Date: November 13, 2021 01:16PM

Hi,

See error-when-migrating-wordpress-database-to-new-server

A priori, this is not a MySQL error, but a WordPress configuration error.

You can try to increase the following values:
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
in the file wamp(64)/alias/phpmyadmin.conf.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.7 32 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.7 64 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36/8.0.27 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: PhpMyAdmin - maxDynRespSize Error
Posted by: disturbed (---.165.22.74.dynamic.ttnet.com.tr)
Date: November 13, 2021 06:28PM

I followed your instructions. But I couldn't find a solution, do you have any other solution suggestions?

Options: ReplyQuote
Re: PhpMyAdmin - maxDynRespSize Error
Posted by: Otomatic (Moderator)
Date: November 13, 2021 07:24PM

Hi,

As I have already written: This is not a MySQL error.

It is an error when exporting to a SQL file.

Have you looked at the last lines of your export file?

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.7 32 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.7 64 bit - Apache 2.4.51 - PHP 8.1.0…5.6.40 - MySQL 5.7.36/8.0.27 - MariaDB 10.5.13/10.6.5
PhPMyadmin 5.1.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.