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		
  • 1 Users Found This Useful

Was this answer helpful?

Related Articles

The MySQL server is currently offline admin bin Cpanel/cpmysql/DBCACHE: exit 11

# This error shows in all user control panels via the "MySQL Databases" icon...   The MySQL...

Increase PHP Memory

Fatal error: Allowed memory size of xxxxxxxxx bytes exhausted (tried to allocate 1064256 bytes)....

What is the path to PHP5?

We are currently running the latest stable version of PHP5. /usr/bin/php

How do I add a user to a MariaDB & MySQL database?

In the MariaDB / MySQL Database section of your hosting control panel, after creating a database...

What port is MariaDB - MySQL on?

MariaDB / MySQL is on Port 3306.