通过 PHPMyAdmin 导出 MySQL 数据库
我希望导出一个只能通过 phpMyAdmin 访问的数据库，以便我可以在本地主机上复制它。我以前从未这样做过，而且数据库相当大，有 200 个表。有人有这样做的经验吗？我只是不确定 phpMyAdmin 的 Web 界面是否是导出这么多数据的可靠方法，或者我尝试导出数据是否会导致一些性能问题。
感谢您的任何建议。如果有帮助的话，你的 phpMyAdmin 版本是 2.1。
I'm hoping to export a database that I only have access to through phpMyAdmin so that I can make a copy of it on my localhost. I've never done this before and the database is fairly large at 200 tables. Does anyone have experience doing this? I'm just unsure if the web interface of phpMyAdmin is a reliable way to export that much data or if I'd be causing some performance issues by attempting to export the data.
Thanks for any advice. Thy phpMyAdmin version is 2.1 if that helps any.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在表中，选择导出，勾选“另存为文件”选项，并将选择保留为“压缩：无”。
您将能够下载这样的巨大数据表。
In the table, select Export, tick the "Save as file" option, and keep the selection as "Compression: None".
You will be able to download huge data tables like this.
您将遇到的问题是 max_execution_time 设置。
我发现大型数据库的转储时间比此处设置的时间长（默认为 30 秒）。
这将导致您的导出失败。
还要确保您没有尝试转储到浏览器，我发现该选项不可靠。选择保存到文件选项，然后通过 ftp 下载转储。
但正如斯拉普内尔上校所说，先尝试一下！
The issue you will come against is the
max_execution_timesetting.What i have found is large databases take longer to dump than what is set here (defaults to 30 seconds).
This will cause your export to fail.
Also make sure you are not trying to dump to the browser, I have found that option unreliable. Choose the save to a file option, and download the dump via ftp .
But as Col. Shrapnel said, try it first!