Mysqldump Error Number 28

Mysqldump Error Number 28

While doing a test migration of a rather sizeable database I started by dumping the database out of MySQL into a file using mysqldump. For me it was a pretty simple issue.

It turns out that if mysqldump has any trouble writing the output stream it will generate error 28, so when I ran:

mysqldump -uroot -p dbname > output.sql

It was generating a 3 TB file and the partition I was on didn't have 3 TB of space. So, after filling that hard drive partition to 100% with a partial data dump, it generated the following error:

mysqldump: Got errno 28 on write

Apparently other write errors can cause this such as a lack of write permissions within the destination directory.

Posted by Tony on Jul 07, 2015 | Linux Tricks, Servers