为什么最新的phpmyadmin删除了sql作为导出格式? [英] Why has the latest phpmyadmin dropped sql as export format?

问题描述

我正在使用phpmyadmin 4.8.4并尝试导出我的一张表作为备份.我注意到sql已被删除为导出文件类型.

I am using phpmyadmin 4.8.4 and have tried to export one of my tables as backup. I noticed that sql has been dropped as an export file type.

为什么会这样?现在，我必须导出为CSV，然后如果要导入，则需要先删除该表.然后，在导入CSV之后，我需要重命名表并确保它使用与原始表相同的排序规则.相比之下，当我可以使用sql导入所有内容而无需进行所有额外工作时，这还需要大量工作.

Why has this happened? I now have to export as CSV and then if I want to import, I need to drop the table first. Then, after I import the CSV, I need to rename the table and make sure it is uses the same collation as the original. This is whole lot more work then when I could use sql as it imported everything and without needing all the extra work.

请有人可以将sql放回原位！！！

Please can someone put sql back!!!

谢谢

马克·金MCP

推荐答案

如果您无权访问phpmyadmin安装程序，则可以在表上进行选择，然后在查询结果操作"的页面底部单击少许导出图标.

If you don't have access to the phpmyadmin install you can do a select on the table then at base of page in "Query results operations" click the little export icon.

这篇关于为什么最新的phpmyadmin删除了sql作为导出格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！