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

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.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

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?

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?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Sorry, only registered users may post in this forum.