Skip to content

Instantly share code, notes, and snippets.

@litanur
Created January 9, 2018 12:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save litanur/c2154607df0184172d379ee0c1e63513 to your computer and use it in GitHub Desktop.
Save litanur/c2154607df0184172d379ee0c1e63513 to your computer and use it in GitHub Desktop.
Solution Errcode: 2 mariadb
Error message:
mysqldump: Error: 'Can't create/write to file '/var/tmp/#sql_662_2.MAI' (Errcode: 2)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `cdef`': Can't create/write to file '/var/tmp/#sql_662_0.MAI' (Errcode: 2) (1)
Solution:
https://prabuddha.me/fix-mariadb-error-innodb-error-unable-create-temporary-file/
In Centos 7, service name of mysql is mariadb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment