phpMyAdmin:& quot; URI太大& quot;

问题描述

我正在使用用于Windows的XAMPP 5.6.15 .我设置了许多具有很多属性和内容的表.
当我单击 phpMyAdmin 中的设计器"，然后单击导出模式"时，出现此错误:

I'm using XAMPP 5.6.15 for Windows. I set up many tables with lots of attributes and some content.
When I click on "Designer" in phpMyAdmin, then on "export schema", I get this error:

请求的URL的长度超出了此限制服务器.该请求无法处理.

The length of the requested URL exceeds the capacity limit for this server. The request cannot be processed.

URI如下所示:

http://localhost/phpmyadmin/schema_export.php?t_x[myTable1.amp_vs_msaccess]=51&t_y[myTable2.amp_vs_msaccess]=152&t_v[myTable3.amp_vs_msaccess]...[myTable500.amp_vs_msaccess]

我已经尝试过PDF，SVG等其他选项.

I already tried different options like PDF, SVG etc.

我想获得我的桌子及其关系的直观表示.

I want to get a visual representation of my tables and their relationships.

还有其他方法可以导出我的模式吗?
我可以切换到 POST 而不是 GET 吗?

Is there any other way to export my schema?
Can I switch to POST instead of GET?

推荐答案

PMA的最大缺点是Web服务器并非旨在处理此类大数据.我已经看到PMA阻塞了10万行.

PMA's biggest drawback is that web servers weren't designed to handle bulk data like that. I've seen PMA choke on as little as 100k rows.

我建议使用mysqldump或 MySQL Workbench (内置了mysqldump实用程序)，直接与MySQL合作，而不是完全依靠PMA进行批量数据移动.

I would suggest mysqldump or MySQL Workbench (which has the mysqldump utility built in) and work directly with MySQL instead of relying solely on PMA for bulk data movement.

这篇关于phpMyAdmin:& quot; URI太大& quot;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！