Search code examples
databaseimportphpmyadminxampp

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.

Solution

  • I had the same problem recently.

    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)