Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→errno 41 - Error dropping database
| Line 142: | Line 142: | ||
* Query the syntax {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'tmpdir';</nowiki>}} to validate the modification of mysql configuration file. | * Query the syntax {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'tmpdir';</nowiki>}} to validate the modification of mysql configuration file. | ||
== 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] | |||
== errno 41 - Error dropping database == | == errno 41 - Error dropping database == | ||
| Line 147: | Line 169: | ||
Solution: [https://stackoverflow.com/questions/17947255/error-in-dropping-a-database-in-mysql-cant-rmdir-oro-errno-41/19888293 phpmyadmin - Error in dropping a database in MySQL (can't rmdir '.\oro', errno: 41) - Stack Overflow] | Solution: [https://stackoverflow.com/questions/17947255/error-in-dropping-a-database-in-mysql-cant-rmdir-oro-errno-41/19888293 phpmyadmin - Error in dropping a database in MySQL (can't rmdir '.\oro', errno: 41) - Stack Overflow] | ||
== 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) == | ||