{"id":6724,"date":"2021-07-24T13:26:28","date_gmt":"2021-07-24T07:56:28","guid":{"rendered":"https:\/\/www.skynats.com\/?p=6724"},"modified":"2024-12-12T14:15:17","modified_gmt":"2024-12-12T08:45:17","slug":"phpmyadmin-incorrect-format-parameter-error","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/phpmyadmin-incorrect-format-parameter-error\/","title":{"rendered":"PhpMyAdmin &#8211; incorrect format parameter error"},"content":{"rendered":"\n<p class=\"has-primary-color has-text-color wp-block-paragraph\"><span class=\"has-inline-color has-primary-color\">PhpMyAdmin<\/span> is a free software tool written in PHP which is intended to handle MySQL or MariaDB database server management.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of our users were approached us for getting this &#8220;PhpMyAdmin incorrect format parameter error&#8221; while importing the database backup file using PhpMyAdmin. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/07\/de1ad5c2a20ff0c144cba29c6d51c8a4.phpMyAdmin_error_incorrect_format_parameter.png\" alt=\"\" class=\"wp-image-6725\" srcset=\"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/07\/de1ad5c2a20ff0c144cba29c6d51c8a4.phpMyAdmin_error_incorrect_format_parameter.png 1024w, https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/07\/de1ad5c2a20ff0c144cba29c6d51c8a4.phpMyAdmin_error_incorrect_format_parameter-300x79.png 300w, https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/07\/de1ad5c2a20ff0c144cba29c6d51c8a4.phpMyAdmin_error_incorrect_format_parameter-768x202.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><span class=\"has-inline-color has-primary-color\">Causes of the PhpMyAdmin<\/span> incorrect format parameter <span class=\"has-inline-color has-primary-color\">error <\/span><\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A script is running more than the defined maximum execution time.<\/li><li>If the requested data exceed the defined limit.<\/li><li>If the script needs more memory than the assigned memory value.<\/li><li>The case when the size of the post data goes higher than the maximum post data size range.<\/li><li>When the size of the backup file is more than the maximum file size limit.<\/li><li>When the MySQL database is corrupted.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span class=\"has-inline-color has-primary-color\">How to fix the issue?<\/span><\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Increase the PHP limits<\/strong><\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">If your PHP parameters like upload maximum file size, maximum execution time, memory limit, etc. are not enough to handle the current upload issue. Then you need to increase the PHP limits in the php.ini file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The php.ini file location can be varied for different servers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can find the php.ini loading path by creating a PHP info file in the webroot of the domain.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If your domain&#8217;s (Eg: skyants.com) document root is the \/home\/user\/www, then create a file named info.php with the below content.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/home\/user\/www\/\nvim info.php\n=================\n&lt;?php phpinfo(); ?&gt;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can access this file by http or https:\/\/skynats.com\/info.php. From here you can get the php.ini file loading path location (Loaded configuration file directive). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So from this, you can edit the php.ini file, in our case, the path is &#8220;\/etc\/php.ini&#8221;. You need to change the given values accordingly based on your requirements.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>max_execution_time = 3000\nmax_input_time = 600\nmemory_limit = 128M\npost_max_size = 100M\nupload_max_filesize = 100M\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If you do not have access to the php.ini file, you can edit the settings in the .htaccess file also (in case of using an apache webserver).<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>php_value max_execution_time = 3000\nphp_value max_input_time = 600\nphp_value memory_limit = 128M\nphp_value post_max_size = 100M\nphp_value upload_max_filesize = 100M<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Restart Apache service in the server for reflecting the changes done.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>service httpd restart\nor\nservice apache2 restart<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the issue still persists then we need to change the execution time parameter in the phpMyAdmin configuration file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The file name is &#8220;config.inc.php&#8221; and for the cPanel servers the file location will be &#8220;\/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/config.inc.php&#8221;.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$cfg&#91;'ExecTimeLimit'] = 2000<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Always try to keep the backup of the editing file before doing any changes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. <strong>Corrupted SQL<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If sometimes the issue occurs due to corrupted SQL scripts, you can replace the current database file with the latest SQL backup available.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. <strong>Manual import of Database backup using SSH<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If none of the above solutions worked, you can import the backup of the database using the SSH option.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u user -p database &lt; backup_file.sql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">No need to be stuck with the issue, our <a href=\"https:\/\/www.skynats.com\/contact-us\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"color:#0381a0\" class=\"has-inline-color\">technical team<\/span><\/a><span style=\"color:#0e0e0e\" class=\"has-inline-color\"> <\/span>is available 24\/7 time to give support.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PhpMyAdmin is a free software tool written in PHP which is intended to handle MySQL or MariaDB database server management. Some of our users were approached us for getting this &#8220;PhpMyAdmin incorrect format parameter error&#8221; while importing the database backup file using PhpMyAdmin. Causes of the PhpMyAdmin incorrect format parameter error A script is running [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[658],"class_list":["post-6724","post","type-post","status-publish","format-standard","hentry","category-blog","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=6724"}],"version-history":[{"count":0,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6724\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=6724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=6724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=6724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}