导出大型数据库mysql phpmyadmin [英] export large database mysql phpmyadmin

问题描述

我在Windows OS上使用phpmyadmin.我有一个带有一个表的数据库，该表具有100M条记录，大小为20GB.我要导出此表并具有table.sql文件.每当我尝试执行此操作时，导出文件的大小为0字节.当我检查apache错误日志时，将显示以下内容:

I am using phpmyadmin on my windows os. I have a database with one table which has 100M records with the size of 20GB. I want to export this table and have the table.sql file. Whenever I try to do this, the size of the exported file is 0 bytes. When I check the apache error log, the following would show up:

Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1066139648 bytes)

有什么办法解决这个问题吗?！

Any idea how to solve this problem?!

谢谢:)

推荐答案

我建议尝试使用命令行和mysqldump.exe实用程序，如建议的

I would suggest to try using the command line and the mysqldump.exe utility, as suggested here

这篇关于导出大型数据库mysql phpmyadmin的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！