15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Installation and Configuration Issues
| Line 19: | Line 19: | ||
# [https://dev.mysql.com/doc/refman/5.7/en/data-directory.html MySQL Data Directory] was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008<ref>[https://errerrors.blogspot.com/2016/12/mysql-windows-server-2008-r2.html 如何修改 MySQL 伺服器的資料目錄 (Windows Server 2008 R2)]</ref> | # [https://dev.mysql.com/doc/refman/5.7/en/data-directory.html MySQL Data Directory] was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008<ref>[https://errerrors.blogspot.com/2016/12/mysql-windows-server-2008-r2.html 如何修改 MySQL 伺服器的資料目錄 (Windows Server 2008 R2)]</ref> | ||
# Directory {{kbd | key=secure-file-priv}} was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008 | # Directory {{kbd | key=secure-file-priv}} was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008 | ||
=== mysqldump: Got errno 32 on write === | |||
Error condition | |||
<pre> | |||
$ mysqldump -h localhost -u root -p --force --single-transaction --default-character-set=utf8 --quick mytable | pv | gzip -c > mytable.sql.gz | |||
</pre> | |||
met the error message: | |||
<pre> | |||
-bash: pv: command not found | |||
... | |||
mysqldump: Got errno 32 on write | |||
</pre> | |||
Root cause | |||
* The pv was not installed | |||
* Input the command to check if pv was installed {{kbd | key=which pv}} | |||
* install pv by input the command: {{kbd | key=sudo yum -y install pv}} <ref>[https://installati.one/centos/7/pv/ How To Install pv on CentOS 7 | Installati.one]</ref> | |||
References | |||
* [https://mysqldump.guru/mysqldump-got-errno-32-on-write.html mysqldump: Got errno 32 on write | mysqldump.guru] | |||
== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) == | == ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) == | ||