importing db phpMyAdmin - Error Incorrect format parameter
I was facing the same issue and tried many things especially increasing the time limits in php.ini
but nothing really worked. Finally I did the job my importing the sql file via command line:
mysql -u username -p databasename < /path/to/file.sql
In most cases the username would be just root
. If you have same tables in both the old database and new database backup file, then you may get an error like this:
ERROR 1050 (42S01) at line 31: Table 'wp_commentmeta' already exists
In that case, drop (delete) existing database and then import the new file via the command stated above.
I had the same error on MAMP i resolve by changing the parameters in php.ini
I followed the instruction by Timmy @enter link description here
; Maximum size of POST data that PHP will accept.
post_max_size = 256M
; Maximum allowed size for uploaded files.
upload_max_filesize = 256M
; Maximum execution time of each script, in seconds
max_execution_time = 600
; Maximum amount of time each script may spend parsing request data
max_input_time = 600
; Maximum amount of memory a script may consume (8MB)
memory_limit = 512M
NOTE1: you can replace values by your own e.g. one can write 5000 in place of 600
NOTE2: restart your Xampp or MAMP.