xampp phpmyadmin, Incorrect format parameter

问题:

Im trying to import the database of my client side (wordpress platform) to localhost (using xampp).

Other clients' sites work OK, except for this one particular site. When I want to import it, it just showed "phpMyAdmin - Error. Incorrect format parameter". The error image

I tried googled it, but it's like no one having this error when importing a database.

Do you guys have any idea? Feel free to ask anything, I'm not sure what information I need to provide since I just using quick exporting and the import setting I just let it remain default.

回答1:

I had the same problem recently. (I upgraded XAMPP and needed to export my MySQL databases from the old to the new and it gave the same error on some databases)

I did these 3 things and it worked:

1. Made sure the Collation of the exported database is the same as the newly created one.

2. Made these changes in my php.ini(xampp/php/php.ini) file

   max_execution_time = 5000
   max_input_time = 5000
   memory_limit = 1000M
   post_max_size = 750M
   upload_max_filesize = 750M
   

3. Made this change in my \phpmyadmin\libraries\config.default.php file:

change

$cfg['ExecTimeLimit'] = 300;

to

$cfg['ExecTimeLimit'] = 0;

(So there is no limit)