Ошибка в импорте дампа
-
DzonWick
- Сообщения: 1
- Зарегистрирован: 20 ноя 2021, 15:29
Ошибка в импорте дампа
Здравствуйте.
Помогите решить проблему с заливкой дампа выдает ошибку ( phpmyadmin — ошибка incorrect format parameter )
крутил параметры в php.ini и тоже не хочет заливаться что делать? Размер файла 383 мб.
;default_socket_timeout = 60
max_execution_time = 3000
;max_file_uploads = 20
;max_input_nesting_level = 64
max_input_time = 60
;max_input_vars = 1000
memory_limit = 1536M
post_max_size = 256M
upload_max_filesize = 256M
-
efendi
- Сообщения: 12
- Зарегистрирован: 04 дек 2016, 21:13
Re: Ошибка в импорте дампа
Непрочитанное сообщение
efendi » 29 дек 2021, 23:28
У меня тоже самое. Жаль, что за 5 суток вам так и не ответили(((
Нужно увеличить эти 2 параметра:
upload_max_filesize
post_max_size
Но Openserver после перезапуска исправляет всё на исходные значения.
Таким образом, не получается загружать БД больше 50 Мб
-
de_kotipan
- Сообщения: 1
- Зарегистрирован: 20 апр 2022, 11:09
Re: Ошибка в импорте дампа
Непрочитанное сообщение
de_kotipan » 20 апр 2022, 11:15
Указанные настройки post_max_size и upload_max_filesize необходимо поменять в папке OpenServeruserdataconfig. Я менял в файле PHP_7.4_php. После перезапуска новые настройки подгрузились и я смог развернуть БД более 50м
Just gone through the same problem when trying to import a CSV (400 MBs) and was also getting an error in red saying
Error — incorrect format parameter
Initially thought it could have been the parameters and tested again. Faster, from my previous experince with it, I realized that it was due to other reasons (size of the file, execution of script has a maximum time defined, etc).
So, I’ve gone to php.ini
and changed the values from the following settings
max_execution_time = 3000
max_input_time = 120
memory_limit = 512M
post_max_size = 1500M
upload_max_filesize = 1500M
After this modification, stoped MySQL and Apache and started them again, went to phpmyadmin trying to import. Then I reached another error
Fatal error: Maximum execution time of 300 seconds exceeded
which was fixed by simply setting in xampp/phpmyadmin/libraries/config.default.php
$cfg['ExecTimeLimit'] = 0;
Setting it to 0 disables execution time limits.
Then, after a while, the import happened without problems.
Во время попытки импортировать базу данных с помощью phpmyadmin, скрипт выдаёт ошибку «Incorrect format parameter». Обычно данная ошибка свидетельствует о неправильных настройках php на хостинге или сервере.
За загрузку максимально допустимого файла, отвечает директива php
— post_max_size
— max_upload_filesize
По умолчанию данная директива может быть как 256, так и 2MB. Обратите внимание на нижнюю картинку, phpmyadmin показывает максимальный размер «8,192 кбит», это чуть больше 8МБ.
И так если у вас хостинг, или VPS, воспользуемся ISPmanager. Нас интересует раздел Настройки->Настройки php
В этом разделе выбираем вашу версию php по умолчанию, и нажимаем на иконку «Основные настройки».
Теперь указываем в поле «Максимальный размер файла и запроса» 8МБ или 64MB, всё зависит от того какой размер файла вы хотите загрузить на сервер. Нажимаем кнопку «ок».
Если у вас собственный сервер, нужно найти файл /etc/php.ini, и изменить директивы:
— post_max_size
— upload_max_filesize
Затем перезагрузить сервер.
В openserver увеличить размер загружаемого файла можно с помощью настройки конфигурации
В открывшемся файле найти директивы, и увеличить их значения. Перезагрузить Openserver
— post_max_size
— upload_max_filesize
PhpMyAdmin Error – incorrect format parameter might appear on multiple hosting platforms like shared hosting, VPS, localhost, or Dedicated Server. You may get incorrect format parameters if you trying to import a heavy MySQL database in MAMP, XAMPP on localhost, or even on some shared hosting. Some VPS or Dedicated Hosting can show this error. This article will show you how to resolve the problem and fix this phpMyAdmin Error.
Table of Contents
- 1 What is the cause of this error?
- 2 Fix phpMyAdmin Error – Incorrect Format Parameter on localhost:
- 2.1 Edit on MAMP php.ini
- 2.2 Edit on Xampp php.ini
- 3 Fix Parameter Format Not Correct on Shared Hosting:
- 3.1 Solution 1: Fix PHPmyadmin error incorrect format parameter by increasing PHP Values
- 3.2 Solution 2: Increase PHP memory limit, time limit in Cpanel
- 4 Fix Incorrect Format Parameter on VPS and Dedicated Server:
What is the cause of this error?
Sometimes, we import the database into MySQL server through PHPMyadmin, incorrect format parameter errors may appear.
PhpMyAdmin Error incorrect format parameter might appear due to multiple reasons such as:
- Execution of a script exceeding the defined maximum execution time on the server.
- Parsing of requested input data exceeds the defined maximum input parsing time.
- Script needing operating memory higher than the one defined in memory limit.
- The size of post data is higher than the defined maximum post data size.
- The size of the file being uploaded is higher than the defined maximum file size.
Find php.ini file and increase these values:
|
upload_max_filesize post_max_size max_execution_time memory_limit |
It depends on your MySQL file and your configuration of the server, but I can suggest these values as below:
|
upload_max_filesize=128M post_max_size=256M max_execution_time=1000 memory_limit=512M |
Edit on MAMP php.ini
To be clearer, I have the same problem and try to find php.ini to edit. But it does not work, when I import MySQL file via phpMyAdmin, I was getting this error: Incorrect Format Parameter. Then I found the cause: I was modifying the wrong php.ini!
Where does MAMP keep its php.ini?
Depending on your version of PHP, there will be 2 php.ini files in MAMP (in this example is PHP 7.2.10):
Applications/MAMP/conf/php7.2.10/php.ini
Applications/MAMP/bin/php/php7.2.10/conf/php.ini
The file you have to edit is in MAMP Pro and uses the php.ini file every time it starts up:
Start MAMP PRO
Edit File > Edit Templates > PHP 7.2.2 php.ini
Restart MAMP Pro
Your changes should stick.
Or you can go by:
MAMP-> bin-> php-> php(your php version)-> conf-> php.ini
If you are not sure where is php.ini, just create a phpinfo.php file at your localhost root. Put this <?PHP phpinfo(); ?> within it, run that from your browser. Look for the value Loaded Configuration File.
This tells you which php.ini file PHP is using in the context of the webserver.
Edit on Xampp php.ini
Let me show you how I solve it easily on my Xampp.
Step 1: Open the Xampp control panel click on the Apache config button and click on PHP (php.ini)
Step 2: Then search the below settings to easily import any database:
|
upload_max_filesize=128M post_max_size=512M max_execution_time=1000 memory_limit=512M |
You can change the above settings as per your database size. then save the file.
Step 3: Now you have to restart the Apache and MySQL.
Step 4: Now you have to import your database SQL file under your database like (demo) and you see that your database will import correctly and the error will be gone.
So if you have more questions on this topic then comment us we will give you more solutions on it.
If the error still exists, open the xampp/phpmyadmin/libraries/config.default.php and disable the script execution time limit. Search for the phrase ExecTimeLimit as shown below.
|
$cfg[‘ExecTimeLimit’] = 300; |
All you have to do is change the ExecTimeLimit value to 0 to get it disabled.
|
$cfg[‘ExecTimeLimit’] = 0; |
Fix Parameter Format Not Correct on Shared Hosting:
Solution 1: Fix PHPmyadmin error incorrect format parameter by increasing PHP Values
If your hosting support changes PHP value via htaccess file, you can easily fix this PHPMyAdmin error by increasing below value by adding this code to htaccess file:
|
php_value memory_limit 512M php_value post_max_size 512M php_value upload_max_filesize 256M |
For Dreamhost Shared Hosting users, you can change max upload size by:
Step 1: Create a .phprc file inside your user folder:
|
/home/[user]/.php/7.2/phprc # change 7.2 to your current php version for example: /home/[user]/.php/7.4/phprc |
Edit that .phprc file and put below content:
|
upload_max_filesize = 512M memory_limit = 512M post_max_size = 512M max_input_vars = 20000 |
Save and kill all PHP processes by login to the server via ssh and running this command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
For PHP 5.6: [server]$ killall —9 php56.cgi —u shelluser For PHP 7.0: [server]$ killall —9 php70.cgi —u shelluser For PHP 7.1: [server]$ killall —9 php71.cgi —u shelluser For PHP 7.2: [server]$ killall —9 php72.cgi —u shelluser For PHP 7.3: [server]$ killall —9 php73.cgi —u shelluser For PHP 7.4: [server]$ killall —9 php74.cgi —u shelluser |
Remember to replace shell user with your SSH username
Solution 2: Increase PHP memory limit, time limit in Cpanel
Login to your Cpanel and go to the Software section, click into Select PHP Version
Next, click on the Options tab and change your desired values to increase the PHP time limit, memory limit in cPanel
Fix Incorrect Format Parameter on VPS and Dedicated Server:
I have CentOS VPS on Vultr, running Nginx, PHP-FPM, MariaDB 10, and all PHP addons. The first time I import my forum DB to phpMyAdmin, it show this error:
|
phpMyAdmin Error incorrect format paramete |
After searching, i found the solution: Open your php.ini on your VPS or Server, edit these value: upload_max_filesize, post_max_size, max_execution_time
It is suggested to increase the values of three variables in the php.ini file.
Change following values in php.ini
|
upload_max_filesize=256M post_max_size=256M max_execution_time=1000 |
Then restart the VPS or server.
This solved my issue.
Database modification can be irritating if it fails with the phpMyAdmin error incorrect format parameter.
And, when this happens midst of a WordPress’s migration, things go for a toss!
Insufficient limits in the server often result in such PHPMyAdmin error.
At Bobcares, we often receive requests to fix phpMyAdmin errors as a part of our Server Management Service.
Today, let’s discuss the phpMyAdmin error incorrect format parameter and analyze how our Support Engineers usually fix it.
What is phpMyAdmin?
Initially, let’s check about PHPMyAdmin.
PhpMyAdmin is a very powerful and handy tool for database management. Certainly, it provides a nice interface to manage the database easily. We can also import backups to the server using the interface.
The scenario of phpMyAdmin error incorrect format parameter
We’ll move on and check the scenario at which the error occurs. Mostly, this error happens in tasks like WordPress migration, moving databases, etc.
Let’s say when users are changing hosting providers or uploading content or databases in the server for production. The files are usually easy to download and configure. However, the database is something that needs efforts if annoying errors appear.
While importing the database backup file, it might result in the PHPMyAdmin error incorrect format parameter.
Causes of phpMyAdmin error incorrect format parameter
We’ll move on and find the possible reasons for the error.
From our expertise in managing servers, incorrect format parameter appears due to multiple reasons such as:
1. Running a script more than the defined maximum execution time.
2. Similarly, if the requested data exceeds the defined limit.
3. The script may need more memory than the defined memory limit.
4. The size of post data goes higher than the defined maximum post data size.
5. Likewise, if the size of the backup file is more than defined maximum file size.
6. Due to corrupted SQL.
How we fix the phpMyAdmin error incorrect format parameter?
Till now we saw the various reasons for the error. Let’s check how our Support Engineers fix each of them.
1. Exceed PHP limits
First of all, we start by checking the PHP parameters.
However, the exact location of the PHP configuration depends on the server we are looking into. Let’s discuss a few such types.
1. If it’s WHM, then the config is located at WHM->Server configuration -> Tweak Settings.
2. For the Ubuntu server with Apache, it is in /etc/php/{PHPversion}/apache2/php.ini.
3. If it’s a local machine with Xammp: xampp/php/php.ini.
4. For Nginx webserver : /etc/php/{PHPversion}.
We change the following parameters based on requirements.
max_execution_time = 3000
max_input_time = 60
memory_limit = 128M
post_max_size = 200M
upload_max_filesize = 200M
We restart the apache service for the changes to reflect. If the issue still persists, we further change the execution time limit in the phpmyadmin configuration file. For WHM/cPanel it is generally located at /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php. Here again, configuration file location may vary depending on the type of server.
We change the below parameter :
$cfg['ExecTimeLimit'] = 1000;
To avoid any errors with the websites, we always take a backup of the configuration files prior to any edit.
2. Possible corrupt SQL
In most cases, increasing PHP limits fix the error. However, at times the error can happen due to corrupt SQL files too. Therefore, we request a fresh backup of the database. As a last resort, our team starts rebuilding the SQL script if the problem exists due to a corrupted SQL file.
3. Manual SQL Import using SSH
In some rare cases, the restore from PHPMyAdmin does not work at all. In such cases, we proceed with manual importing of the database backup via SSH. Further, we always add the necessary privileges to the database user too.
[Having trouble in fixing phpmyadmin errors? – We’ll fix it for you.]
Conclusion
In short, WordPress migration often results in PHPMyAdmin error incorrect format parameter due to insufficient PHP limits on the server, corrupt SQL, etc. Today, we saw how our Support Engineers fixes the PHPMyAdmin incorrect format error.
PREVENT YOUR SERVER FROM CRASHING!
Never again lose customers to poor server speed! Let us help you.
Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.
GET STARTED
var google_conversion_label = «owonCMyG5nEQ0aD71QM»;
Today, we’ll explain to you how to fix phpMyAdmin error – “Incorrect format parameter” that occurred when importing the database in phpMyAdmin.
Error:
phpMyAdmin – Error
Incorrect format parameter
Look at the following image for your reference.
Reasons for phpMyAdmin error – Incorrect format parameter
There are multiple reasons for phpMyAdmin error – Incorrect format parameter such as:
- Script runs longer than defined maximum execution time.
- Requested input data exceeds the defined limit.
- Script memory higher than the defined memory limit.
- Size of post data higher than the defined maximum post data size.
- Size of the file more than defined maximum file size.
Fixed the phpMyAdmin error – Incorrect format parameter
Now, we need to update or increase the value of the all above settings in the php.ini file. In the local machine php.ini file is located on xampp/php/php.ini and
In the ubuntu server it will be found on /etc/php/{PHPversion}/apache2/php.ini.
Now we will update the settings in the php.ini file as per the requirements as given below.
|
max_execution_time = 3000 max_input_time = 600 memory_limit = 512M post_max_size = 256M upload_max_filesize = 256M |
After that restart the apache server to reflect the changes. If the error still occurs then open phpmyadminlibrariesconfig.default.php file and change the value of the ExecTimeLimit parameter to disable the script execution time limit.
You will find it in config.default.php file as below.
|
$cfg[‘ExecTimeLimit’] = 300; |
We need to set the value to 0 to disable the execution time limit as follows.
|
$cfg[‘ExecTimeLimit’] = 0; |
That’s it for today.
Thank you for reading. Happy Coding..!!
If you found value in this article,
you can support us by buying me a coffee! ☕
Learn how to fix the PHPMyAdmin error that appears when you try to import a database (Incorrect format parameter).
In the last days, a friend of mine asked for help in a very old project that uses PHP 5.4, so I had to install a compatible version of xampp for that version of PHP. I configured the php.ini file really fast because I wanted to work on other stuff, however I committed a newbie mistake as I adjusted just a single parameter in the php.ini file that should allow me to import bigger SQL files directly in the browser.
In this article, I will explain you why this exception occurs and how to solve it in your local environment of XAMPP.
How to trigger this exception
If you decide to modify the post_max_size and upload_max_filesize properties of the configuration file of PHP, you need to be careful, because, if you decide to assign a greater value to upload_max_filesize than the allowed size for post_max_size , the exception will be triggered. For example, if you set 2MB to the allowed post max size and 8MB to the max upload filesize like this in your php.ini file:
; Maximum size of POST data that PHP will accept.
; Its value may be 0 to disable the limit. It is ignored if POST data reading
; is disabled through enable_post_data_reading.
; http://php.net/post-max-size
post_max_size=2M
; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize=8MIf you try to upload a database to import through PHPMyAdmin, the exception will be thrown.
How to prevent or solve this exception
Be sure to set equal values to the mentioned properties post_max_size and upload_max_filesize. It’s just logic, as if you configure a value of these properties greater than the other one, it simply won’t work, for example, you cannot upload a file of 5MB if your max allowed filesize is of 8MB (theoretically the filesize passes), but the max allowed POST size is of only 2M, it just doesn’t make sense. Fix the values to use the same number and that should be enough (the value can be whatever you need to, not specifically 64MB):
; Maximum size of POST data that PHP will accept.
; Its value may be 0 to disable the limit. It is ignored if POST data reading
; is disabled through enable_post_data_reading.
; http://php.net/post-max-size
post_max_size=64M
; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize=64MHappy coding ❤️!