Deciphering Mysql Fault Codes
I was tasked to upgrade the mysql server running on the Centos server.
Of course, the receive down matter I should produce was to backup my database. I run the mysqldump ascendancy below to write out the sql statements that volition simulate too populate the database tables.
# mysqldump -uroot -p -l --opt --all-databases=true > /root/mysqlall.sql mysqldump: Couldn't execute 'show fields from `asset`': Got fault 28 from storage engine (1030)
Lo too behold, I got an "error 28". What is "error 28"? The fault message has no useful details that could attention me troubleshoot.
The perror ascendancy came inwards handy inwards that situation.
# perror 28 OS fault code 28: No infinite left on device
Now, a quick df ascendancy confirmed that the hard-drive was full.
perror explains organization fault codes generated past times mysql too the base of operations OS(Linux).
0 Response to "Deciphering Mysql Fault Codes"
Post a Comment