Resolve Mysqldump:couldn T execute Show fields from table error

When maintaining a Web site today, when backing up a database in a Windows environment

Use of mysqldump

After the execution, the prompt error is as follows

Mysqldump:couldn ' t execute ' show fields from ' table ': Can ' t create/write to file ' w:/systemp/#sql7c4_48_5. Myi ' (Errcode: 2) (1)

The last access to information, said to be a matter of authority, but found that as long as the My.ini set a tmpdir path on it
Set up a temporary folder for MySQL

Tmpdir=d:/mysqltmp

Then remember to restart the database service

net stop MySQL
net start MySQL

You can then export the database using the mysqldump command to export it normally.