phpMyAdmin - Error Incorrect format parameter

When importing a database with phpMyAdmin I receive the error "Error Incorrect format parameter".  This can often occur due to memory or timeout restrictions with very large SQL export files.  If you have access to a terminal/shell and can run the MySQL command as root to import the database, example:

mysql database_name < export.sql


That can often get you around the issue. If not, you may find increasing the following values may rectify the issue via your php.ini file if one is used for your PHP environment:

max_execution_time = 3000
max_input_time = 600
memory_limit = 500M
post_max_size = 500M
upload_max_filesize = 500M	

If you do not have access to a php.ini, setting the following in your .htaccess file may do the trick:

php_value max_execution_time = 3000
php_value max_input_time = 600
php_value memory_limit = 500M
php_value post_max_size = 500M
php_value upload_max_filesize = 500M		

 

If you've tried all of the above steps and the error is still occurring, you may need to contact our support for assistance. We will be able to help you identify and resolve the issue.

 

  • 1 Users Found This Useful

Was this answer helpful?

Related Articles

Useful CSV to MySQL Script

The link below is a great tool we have run into for converting CSV files into MySQL format:CSV to...

When trying to connect to MariaDB or MySQL you receive error 2003 Cannot connect to MySQL on xxxxxx on port 3306 10060

The error 2003 "Cannot connect to MySQL on xxxxxx on port 3306 10060" means that the MySQL...

Warning: Unknown(): open_basedir restriction in effect

Basedir restriction is set for security. This most often occurs when you are calling an app...

Clean - Shrink ibdata1

To shrink ibdata1 once and for all you must do the following:MySQLDump all databases into a SQL...

Error 500 - Internal Server Error - PHP

This can be due to several factors. The first thing to check is that the permissions on the file...