blocks|key|1632558|text|此问题并不是由于数据库损坏造成的。我从这个视频中找到了解决方案--+https://www.youtube.com/watch?v=MqOsp54EA3I|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1632559|建议增加php.ini文件中两个变量的值。php.ini中的更改跟踪|1632560|upload_max_filesize=64M
post_max_size=64M|code-block|syntax|javascript|1632561|然后重新启动服务器。|1632562|这解决了我的问题。希望也能解决你的问题。|1632563|entityMap|0|LINK|mutability|MUTABLE|url|https://www.youtube.com/watch?v=MqOsp54EA3I^0|Y|17|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

This issue is not because of corrupt database. 
I found the solution from this video - <a href="https://www.youtube.com/watch?v=MqOsp54EA3I" rel="noreferrer">https://www.youtube.com/watch?v=MqOsp54EA3I</a>

It is suggested to increase the values of two variables in php.ini file.
Change following in php.ini

<pre><code>upload_max_filesize=64M
post_max_size=64M
</code></pre>

Then restart the server.

This solved my issue. Hope solves yours too.

blocks|key|1632622|text|我能够通过以下发布的步骤来解决这个问题：xampp+phpmyadmin,+Incorrect+format+parameter|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1632623|因为我没有使用XAMPP，所以我还需要将我的php.ini.default更新为php.ini，这最终做到了这一点。|style|CODE|1632624|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/50201874/xampp-phpmyadmin-incorrect-format-parameter^0|K|18|0|0|M|F|14|7|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@$A|U|B|V|F|G]|$A|W|B|X|F|G]]|9|@]|C|$]]|$1|H|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

I was able to resolve this by following the steps posted here: <a href="https://stackoverflow.com/questions/50201874/xampp-phpmyadmin-incorrect-format-parameter">xampp phpmyadmin, Incorrect format parameter</a>

Because I'm not using XAMPP, I also needed to update my <code>php.ini.default</code> to <code>php.ini</code> which finally did the trick.

blocks|key|2689523|text|这些答案对我都没有用。我不得不使用命令行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2689524|mysql+-u+root+db_name+<+db_dump.sql
SET+NAMES+'utf8';
SOURCE+db_dump.sql;|code-block|syntax|javascript|2689525|完成了！|2689526|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

None of these answers worked for me. I had to use the command line:

<pre><code>mysql -u root db_name &lt; db_dump.sql
SET NAMES 'utf8';
SOURCE db_dump.sql;
</code></pre>

Done!

blocks|key|1632642|text|压缩.sql文件，并确保将其命名为.[format].[compression]，即database.sql.zip。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1632643|如上所述，如果您的PhpMyAdmin文件大于允许的最大上传大小，则.sql会抛出此错误--但是，在我的示例中，最大值是50+Max，尽管我在前面的答案中已经设置了所有选项(查找PhpMyAdmin中上传按钮旁边的"Max:+50MiB“)。|1632644|entityMap^0|2|4|H|N|16|G|0|Y|4|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|I|$]]

Compress your <code>.sql</code> file, and make sure to name it <code>.[format].[compression]</code>, i.e. 
<code>database.sql.zip</code>. 

As noted above, PhpMyAdmin throws this error if your <code>.sql</code> file is larger than the Maximum allowed upload size -- but, in my case the maximum was 50MiB despite that I had set all options noted in previous answers (look for the "Max: 50MiB" next to the upload button in PhpMyAdmin).

blocks|key|2689590|text|对我来说，调整这两个值是不够的。如果文件太大，还需要调整执行时间变量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2689591|首先，./php/php.ini|2689592|upload_max_filesize=128M
post_max_size=128M
max_execution_time=1000|code-block|syntax|javascript|2689593|然后，./phpMyAdmin\库\config.default.php|2689594|$cfg['ExecTimeLimit']+=+1000;|2689595|这对我起了作用。当然，变量的选择也是不同的。也许执行时间还得更长。大小取决于你的文件大小。|2689596|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For me, adjusting the 2 values was not enough. If the file is too big, you also need to adjust the execution time variables.

First, ../php/php.ini

<pre><code>upload_max_filesize=128M
post_max_size=128M
max_execution_time=1000
</code></pre>

Then, ../phpMyAdmin\libraries\config.default.php

<pre><code>$cfg['ExecTimeLimit'] = 1000;
</code></pre>

This did the trick for me. The variables can be choosen differently of course. Maybe the execution time has to be even higher. And the size depends on your filesize.

blocks|key|1632685|text|我犯了这个错误，由于我正在共享主机，所以我无法访问php.ini，所以不知道如何修复它，主机似乎也没有任何线索。最后，我清空了我的浏览器缓存并重新加载了phpmyadmin，它回来了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1632686|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had this error and as I'm on shared hosting I don't have access to the php.ini so wasn't sure how I could fix it, the host didn't seem to have a clue either. In the end I emptied my browser cache and reloaded phpmyadmin and it came back!

blocks|key|1632717|text|此错误是由最大上传大小为(最大值:2,048+Max)造成的。如果您的文件大于此，您将得到一个错误。压缩文件并再次上传，您将不会得到错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1632718|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This error is caused by the fact that the maximum upload size is (Max: 2,048KiB). If your file is bigger than this, you will get an error. Zip the file and upload it again, you will not get the error.

blocks|key|2689709|text|刚刚在试图导入CSV+(400+MBs)时也遇到了同样的问题，并且在红色谚语中也出现了错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2689710|错误-格式参数不正确|blockquote|2689711|最初认为这可能是参数，并再次测试。更快，从我之前的经验，我意识到这是由于其他原因(文件的大小，脚本的执行有一个最大的时间定义，等等)。|2689712|所以，我去了php.ini|2689713|​|2689714|📷|atomic|offset|length|2689715|2689716|并从下列设置中更改值|2689717|max_execution_time+=+3000
max_input_time+=+120
memory_limit+=+512M
post_max_size+=+1500M
upload_max_filesize+=+1500M+|code-block|syntax|javascript|2689718|修改后，停止了MySQL和Apache并重新启动它们，然后转到phpmyadmin试图导入。然后我找到了另一个error|2689719|致命错误:超过300秒的最大执行时间|2689720|通过简单地在xampp/phpmyadmin/libraries/config.default.php中设置就可以解决这个问题。|2689721|2689722|2689723|2689724|$cfg['ExecTimeLimit']+=+0;|2689725|将其设置为0将禁用执行时间限制。|2689726|然后，过了一段时间，进口就没有问题了。|2689727|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/d84f6abba7ff88b0fc1d13a9e7fbfbea.png|imageAlt|1|LINK|MUTABLE|url|https://stackoverflow.com/a/13858161/5675325|2|https://developer.qcloudimg.com/http-save/yehe-900000/259e2fc2754ac978ec572c9d6ac97082.png^0|0|0|0|0|0|0|1|0|0|0|0|0|1J|5|1|0|0|0|0|0|1|2|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1T|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|1U|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1V|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1W|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1X|8|@]|9|@$N|1Y|O|1Z|1|20]]|A|$]]|$1|P|3|J|5|6|7|21|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|22|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|23|8|@]|9|@]|A|$V|W]]|$1|X|3|Y|5|6|7|24|8|@]|9|@$N|25|O|26|1|27]]|A|$]]|$1|Z|3|10|5|D|7|28|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|29|8|@]|9|@]|A|$]]|$1|13|3|J|5|6|7|2A|8|@]|9|@]|A|$]]|$1|14|3|L|5|M|7|2B|8|@]|9|@$N|2C|O|2D|1|2E]]|A|$]]|$1|15|3|J|5|6|7|2F|8|@]|9|@]|A|$]]|$1|16|3|17|5|U|7|2G|8|@]|9|@]|A|$V|W]]|$1|18|3|19|5|6|7|2H|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2I|8|@]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]]|1D|$1E|$5|1F|1G|1H|A|$1I|1J|1K|-4]]|1L|$5|1M|1G|1N|A|$1O|1P]]|1Q|$5|1F|1G|1H|A|$1I|1R|1K|-4]]]]

Just gone through the same problem when trying to import a CSV (400 MBs) and was also getting an error in red saying

<blockquote>
 Error - incorrect format parameter
</blockquote>

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

<a href="https://i.stack.imgur.com/43BLb.png" rel="noreferrer"><img src="https://i.stack.imgur.com/43BLb.png" alt="php.ini"></a>

and changed the values from the following settings

<pre><code>max_execution_time = 3000
max_input_time = 120
memory_limit = 512M
post_max_size = 1500M
upload_max_filesize = 1500M 
</code></pre>

After this modification, stoped MySQL and Apache and started them again, went to phpmyadmin trying to import. Then I reached another <a href="https://stackoverflow.com/a/13858161/5675325">error</a>

<blockquote>
 Fatal error: Maximum execution time of 300 seconds exceeded
</blockquote>

which was fixed by simply setting in xampp/phpmyadmin/libraries/config.default.php

<a href="https://i.stack.imgur.com/4DxnP.png" rel="noreferrer"><img src="https://i.stack.imgur.com/4DxnP.png" alt="config.default.php"></a>

<pre><code>$cfg['ExecTimeLimit'] = 0;
</code></pre>

Setting it to 0 disables execution time limits.

Then, after a while, the import happened without problems.

blocks|key|2928366|text|上面的任何一个答案都没有为我解决。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2928367|我甚至在我的xampp中也找不到“库”文件夹。|2928368|因此，我简单地使用以下命令重新启动：|2928369|sudo+service+apache2+restart|code-block|syntax|javascript|2928370|和|2928371|sudo+service+mysql+restart

Just+restarted+apache+and+mysql.+Logged+in+phpmyadmin+again+and+it+worked+as+usual.|2928372|谢谢我..！|2928373|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

None of the above answers solved it for me.

I cant even find the 'libraries' folder in my xampp - ubuntu also.

So, I simply restarted using the following commands:

<pre><code>sudo service apache2 restart
</code></pre>

and

<pre><code>sudo service mysql restart

Just restarted apache and mysql. Logged in phpmyadmin again and it worked as usual.
</code></pre>

Thanks me..!!

blocks|key|2928391|text|没有任何问题，我直接从命令行导入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2928392|mysql+-uroot+-hURLServer+-p+DBName<+filename.sql|code-block|syntax|javascript|2928393|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Without any problems, I imported directly from the command line.

<pre><code>mysql -uroot -hURLServer -p DBName&lt; filename.sql
</code></pre>

blocks|key|2928437|text|我遇到了这个问题，但是对于一个码头容器(phpmyadmin用户)，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2928438|解决方案：|2928439|输入phpmyadmin容器docker+exec+-it+idcontainer+/bin/bash|unordered-list-item|offset|length|style|CODE|2928440|移动cd+/usr/local/etc/php/|2928441|创建php.ini文件|2928442|修改它upload_max_filesize=128M++++++++++post_max_size=128M++++++++++max_execution_time=1000|2928443|保存并重新启动容器。|2928444|这个问题发生在Windows上，在Linux上我不需要这样做。|2928445|entityMap^0|0|0|E|11|0|2|M|0|2|7|0|3|2D|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@$G|Z|H|10|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|11|8|@$G|12|H|13|I|J]]|9|@]|A|$]]|$1|M|3|N|5|F|7|14|8|@$G|15|H|16|I|J]]|9|@]|A|$]]|$1|O|3|P|5|F|7|17|8|@$G|18|H|19|I|J]]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1A|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1B|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|V|$]]

I had this problem but with a docker container (phpmyadmin users),

Solution:

<ul>
<li>Enter in the phpmyadmin container <code>docker exec -it idcontainer /bin/bash</code></li>
<li>Move <code>cd /usr/local/etc/php/</code></li>
<li>Create <code>php.ini</code> file</li>
<li>Modify it <code>upload_max_filesize=128M
 post_max_size=128M
 max_execution_time=1000</code></li>
<li>Save and restart container.</li>
</ul>

This problem was in a Windows pc, at Linux i didnt need to do this.

blocks|key|2928538|text|注意:如果使用MAMP，则必须使用内置编辑器编辑文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2928539|选择PHP在语言部分(LH菜单列)下一步，在主面板旁边的默认版本下拉单击指向右侧的小箭头。这将使用MAMP文本编辑器启动php.ini文件。在重新启动服务器后，对此文件所做的任何更改都将保持不变。|offset|length|style|BOLD|CODE|2928540|通过Application->MAMP->bin->php->{choosen+the+version}->php.ini编辑文件将无法工作。因为应用程序覆盖了您所做的任何更改。|2928541|不用说：“龙在这里！”因此，请剪切和粘贴原件的副本，并保存在安全的地方，以防发生灾难。|2928542|📷|atomic|2928543|​|2928544|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/56ad5fc13749a95c236c2ed3aa3e3f91.jpg|imageAlt^0|0|1O|7|1O|7|0|2|1N|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|H]]|9|@]|A|$]]|$1|I|3|J|5|6|7|16|8|@$D|17|E|18|F|H]]|9|@]|A|$]]|$1|K|3|L|5|6|7|19|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

Note: If you're using MAMP you MUST edit the file using the built-in editor.
Select PHP in the languages section (LH Menu Column) Next, in the main panel next to the default version drop-down click the small arrow pointing to the right. This will launch the <code>php.ini</code> file using the MAMP text editor. Any changes you make to this file will persist after you restart the servers.
Editing the file through <code>Application-&gt;MAMP-&gt;bin-&gt;php-&gt;{choosen the version}-&gt;php.ini</code> would not work. Since the application overwrites any changes you make.
Needless to say: &quot;Here be dragons!&quot; so please cut and paste a copy of the original and store it somewhere safe in case of disaster.<a href="https://i.stack.imgur.com/id2fX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/id2fX.jpg" alt="enter image description here" /></a>

blocks|key|2928581|text|如果您使用docker-组合，只需设置UPLOAD_LIMIT。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2928582|phpmyadmin:
++++image:+phpmyadmin/phpmyadmin
++++environment:
++++++++UPLOAD_LIMIT:+1G|code-block|syntax|javascript|2928583|entityMap^0|J|C|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

If you use docker-compose just set <code>UPLOAD_LIMIT</code>
<pre><code>phpmyadmin:
 image: phpmyadmin/phpmyadmin
 environment:
 UPLOAD_LIMIT: 1G
</code></pre>

blocks|key|1632984|text|如果您不能上传导入文件，因为您的大小很大，并且您不能修改参数，因为您是在共享主机上，请尝试在您的计算机上安装HeidiSQL并从那里加载文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1632985|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you can't upload import file due to big size and you can't modify parameters because you are in a shared hosting try to install on your computer HeidiSQL and load file from there.

blocks|key|2928631|text|当您更改这里提到的PHP设置并继续导入数据库而不首先重新启动Apache时，就会发生这种情况。这将导致触发错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2928632|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This tends to occur when you change the PHP settings as mentioned here and continue to import the database without first restarting Apache. That causes the error to be triggered.

blocks|key|2690003|text|在命令行上使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2690004|C:\Windows\system32>+mysql+-u+root+-p

mysql>+use+desired_db;
mysql>+source+db_backup.sql;|code-block|syntax|javascript|2690005|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On the command line use
<pre><code>C:\Windows\system32&gt; mysql -u root -p

mysql&gt; use desired_db;
mysql&gt; source db_backup.sql;
</code></pre>

blocks|key|2690111|text|您可以使用xampp+shell。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2690112|打开Xampp并单击shell|ordered-list-item|2690113|📷|atomic|offset|length|2690114|​|2690115|键入以下命令mysql+-u用户名-p+-v+database_name+<+"/path/file.sql“|2690116|示例:用户名:root|2690117|++++++password+:+leave+blank|code-block|syntax|javascript|2690118|database_name是您要导入的数据库(导入前创建此数据库)|2690119|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/4da24389e4e94ce9019bcde25a2e713a.png|imageAlt^0|0|0|0|1|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|16|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|17|8|@]|9|@$H|18|I|19|1|1A]]|A|$]]|$1|J|3|K|5|6|7|1B|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1E|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1F|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]]]

You can use xampp shell
<ol>
<li>Open Xampp and click shell
<a href="https://i.stack.imgur.com/jD3xN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jD3xN.png" alt="enter image description here" /></a></li>
</ol>
Type the following command
mysql -u username -p -v database_name &lt; &quot;/path/file.sql&quot;
example : username :root
<pre><code> password : leave blank
</code></pre>
database_name is the database you are importing to (create this database before importing)

blocks|key|2690128|text|解决了！有两个简单的步骤。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2690129|在php.ini中
max_execution_time+=+600
max_input_time+=+600
memory_limit+=1024+M
post_max_size+=1024+M|ordered-list-item|2690130|my.ini
max_allowed_packet+=1024+M|2690131|entityMap^0|0|4|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|Q|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|L|$]]

Solved! with 2 simple steps.
<ol>
<li>in php.ini
max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M
</li>
<li>my.ini
max_allowed_packet = 1024M
</li>
</ol>

blocks|key|1633154|text|如果使用wampp和windows+11，则打开文件夹C:\wamp64\alias\phpmyadmin.conf。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1633155|更新值|1633156|php_admin_value+upload_max_filesize+128M
php_admin_value+post_max_size+128M
php_admin_value+max_execution_time+360
php_admin_value+max_input_time+360|code-block|syntax|javascript|1633157|至|1633158|php_admin_value+upload_max_filesize+1028M
php_admin_value+post_max_size+1028M
php_admin_value+max_execution_time+3600
php_admin_value+max_input_time+3600|1633159|entityMap^0|R|V|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

If You are using wampp and windows 11
open folder
C:\wamp64\alias\phpmyadmin.conf
update values
<pre><code>php_admin_value upload_max_filesize 128M
php_admin_value post_max_size 128M
php_admin_value max_execution_time 360
php_admin_value max_input_time 360
</code></pre>
to
<pre><code>php_admin_value upload_max_filesize 1028M
php_admin_value post_max_size 1028M
php_admin_value max_execution_time 3600
php_admin_value max_input_time 3600
</code></pre>

I have a WordPress production website.

I've exported the database by the following commands: <code>select database &gt; export &gt; custom &gt; select all tables &gt; select .zip compression &gt; 'Go'</code>

I've downloaded the file which is example.sql.zip but when I upload to my localhost I get this error: <code>phpMyAdmin - Error &gt; Incorrect format parameter</code>

I've tried to export with other formats and I get the same error.

I've tried with other SQL Databases and it exports/ imports just fine.

What could it be? A corrupt database or other?

Thanks

phpMyAdmin - Error > Incorrect format parameter?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个WordPress制作网站。我通过以下命令导出了数据库：select database > export > custom > select all tables > select .zip compression > 'Go'我已经下载了这个文件，它是example.sql.zip，但是当我上传到我的本地主机...

问phpMyAdmin -错误>不正确的格式参数？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpMyAdmin -错误>不正确的格式参数？EN