如何通过phpmyadmin导入非常大的查询? [英] how to import a very large query over phpmyadmin?

问题描述

如果我的主机不允许我直接将文件上传到我的mysql文件夹 我只能通过phpmyadmin这样做吗?除了它的本机导入功能外，还有什么其他选择可以使我的连接在上载大约8mb的查询时不会超时吗?

if my host does not allow me to upload a file directly to my mysql folder and i can only do so throught phpmyadmin? are there any alternatives aside from its native import feature so that my connection would not time out while uploading a query that's around 8mb?

推荐答案

您可以gzip或bzip该文件，然后phpMyAdmin将解压缩并运行脚本.

you can gzip or bzip the file and phpMyAdmin will decompress and run the script.

否则，我过去要做的就是将SQL拆分为多个文件，然后分别加载每个文件.您只需在文本编辑器中打开SQL文件，向下滚动到一半左右，找到一条语句的开头，然后将所有内容移动到另一个文件中即可.

otherwise what I've had to do in the past is split my SQL into a number of files and load each one individually. You can do this simply by opening the SQL file in a text editor, scroll to about half way down, find the start of a statement and move everything after that into another file.

这篇关于如何通过phpmyadmin导入非常大的查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！