MySQL mysqldump：写入时出现 errno 28
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/37697886/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
mysqldump: Got errno 28 on write
提问by Mangesh Sathe
I am getting this error even if I have plenty of space on my drives.
即使我的驱动器上有足够的空间，我也会收到此错误。
https://sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-writesays its disk space problem.
https://sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-write说它的磁盘空间问题。
I am using PUTTY and this command to export database
我正在使用 PUTTY 和这个命令来导出数据库
mysqldump -h [HOST] --port=[PORT] -u [USERNAME] -p [DBNAME] > E:\[FILENAME].sql
回答by Maduka Jayalath
Error Message
错误信息
Backup failed: mysqldump: Got errno 28 on write
备份失败：mysqldump：写入时得到 errno 28
Meaning
意义
Insufficient disk space to store output.
磁盘空间不足，无法存储输出。
Solution
解决方案
Free up some disk space. You might want to track down the reason you're low on disk space too.
释放一些磁盘空间。您可能还想找出磁盘空间不足的原因。
Source:https://sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-write
来源：https : //sittinginoblivion.com/wiki/backup-failed-mysqldump-got-errno-28-write
回答by gtryonp
I came here with the same problem, plenty of space. Also putty.
我带着同样的问题来到这里，有足够的空间。还有腻子。
I noticed than using the same command but in another folder with mod 777 (write everybody) the problem of space is gone and the command runs succesfully.
我注意到不是使用相同的命令，但在另一个文件夹中使用 mod 777（写给大家）空间问题消失了，命令成功运行。
回答by sin.hyp.a
I got the same error but it turned out that there was no memory left to accommodate a new file. Removing unwanted files to free up the space for new (*.sql) file helped.
我遇到了同样的错误，但结果是没有剩余的内存来容纳新文件。删除不需要的文件以释放新 (*.sql) 文件的空间有所帮助。
P.S: You can see your memory consumption by the command: df -h.
PS：可以通过命令查看你的内存消耗：df -h。
回答by Mangesh Sathe
There is something wrong with putty.
腻子有问题。
Dont use putty, Just go to windows command prompt, Go to folder where mysql.exe, mysqldump.exe etc.. are there & just enter this command.
不要使用腻子，只需转到 Windows 命令提示符，转到 mysql.exe、mysqldump.exe 等所在的文件夹，只需输入此命令即可。
Remember never try to take dump from MYSQL>command prompt
记住永远不要尝试从MYSQL>命令提示符下进行转储
C:\xampp\mysql\bin>mysqldump -h [HOST] --port=[PORT] -u [USERNAME] -p [DBNAME] > E:[FILENAME].sql
C:\xampp\mysql\bin>mysqldump -h [HOST] --port=[PORT] -u [USERNAME] -p [DBNAME] > E:[FILENAME].sql
Enter password: ------
输入密码： - - -
Worked perfectly!!
完美运行！！
