MySQL Export database error: Error 1030 (HY000): Got error from storage engine

When exporting the Test.sql database on Linux, an error has occurred: Error1030 (HY000): Got error from storage engine. I checked this out later because MySQL has insufficient default temporary directory space to execute this SQL statement:

Command line execution under: Show variables like '%dir% ',

Basedir | /usr/local/mysql |
| Binlog_direct_non_transactional_updates | OFF |
| Character_sets_dir | /usr/local/mysql/share/charsets/|
| DataDir | /xx/mysql/var/|
| Innodb_data_home_dir | /xxg/msql/var |
| Innodb_log_group_home_dir | /xx/mysql/var |
| innodb_max_dirty_pages_pct | 75 |
| Lc_messages_dir | /usr/local/mysql/share/|
| Plugin_dir | /usr/local/mysql/lib/plugin/|
| Slave_load_tmpdir | /tmp |
| Tmpdir | /tmp

You can see that the current temp directory for MySQL is/tmp, and then DF-HL or du-sh/tmp to see if the directory still has space, the result is not enough space, so modify the configuration file/etc/my.cnf, under "mysqld" add Tmpdir =/xx/tmp. Save, restart, export again is not the problem.

Note: Sometimes modifying a configuration file, such as/etc/my.cnf,wq, will prompt for E514:write error (file system full), and it is possible that the disk space for the directory where the/etc/resides is lost.

MySQL Export database error: Error 1030 (HY000): Got error from storage engine