Incorrect key file for table '/tmp/#sql_882_0. MYI '; Try to repair it

The method of repairing the table is as follows:

One law:. Check table and Repair table methods
1. Go to MySQL's DOS console and enter the password

2,use database; (Name of your databases)

3, check table tabtest;
If the result says status is OK, then do not repair, if there is error, you can use:

> Repair table tabtest;

Another likely cause is a lack of temporary folder space, which may occur when large data join,order by, and the temporary folder path needs to be modified

To add the Tmpdir parameter to the start command:

/usr/bin/mysqld_safe--defaults-file=/etc/my.cnf--pid-file= "$mypidfile"--log-error= "$errlogfile"--tmpdir=/var/ Tmp

Incorrect key file for table '/tmp/#sql_882_0. MYI '; Try to repair it