Mysql error 28 no space left on the device|no space left on device error in mysql

"No space left on device" 
This Error occurs when there is no space on the mysql database drive.

Example:

Solution:

There is not enough disk space to run the database.
MySQL cannot create a temporary file for the result set in the temporary directory.
So Increase the space for the database in the /tmp folder.