WampServer

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

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

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

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