If you are trying to import a database and meet the "Incorrect Format Parameter" error, it might be because the file you are trying to import is larger than the maximum allowed upload size or/and that the process timed out.

You might want to:

  • increase the max_exection_time
  •  compress your .sql file, and make sure to name it .[format].[compression], i.e. database_dump.sql.zip.

 

Please check to see the values for these directives via Softwares >>> MultiPHP INI Editor for cPanel after logging in to your cPanel.:

  •  upload_max_filesize=$value
  •  post_max_size=$value
  • max_execution_time=$value

 

You might also consider using the command line as in:

mysql -u root db_name < database_dump.sql

SET NAMES 'utf8';

SOURCE database_dump.sql;

Another reason why this will happen is if the SQL is corrupted.

Was this answer helpful? 1 Users Found This Useful (1 Votes)