Archives

fix for ERROR 1 (HY000): Can’t create/write to file ‘/tmp/#sql_df5_1.MYI’ (Errcode: 13)

Recently, I came accros this error while trying to export some data into a file  using a select query into /tmp. I would like to explain the fix that worked for me.
chown root:root /tmp
chmod 1777 /tmp
/etc/init.d/mysqld restart

Hope this help you guys

mysql server errors, SQLSTATE: HY000,list of all mysql server errors

Error Code
SQL State
Message

Error: 1000
SQLSTATE: HY000 ER_HASHCHK
Message: hashchk

Error: 1001
SQLSTATE: HY000 ER_NISAMCHK
Message: isamchk

Error: 1002
SQLSTATE: HY000 ER_NO
Message: NO

Error: 1003
SQLSTATE: HY000 ER_YES
Message: YES

Error: 1004
SQLSTATE: HY000 ER_CANT_CREATE_FILE
Message: Can’t create file ‘%s’ errno: %d

Error: 1005
SQLSTATE: HY000 ER_CANT_CREATE_TABLE
Message: Can’t create table ‘%s’ errno: %d

Error: 1006
SQLSTATE: HY000 ER_CANT_CREATE_DB
Message: Can’t create database ‘%s’ errno: %d

Error: 1007
SQLSTATE: HY000 ER_DB_CREATE_EXISTS
Message: [...]

dump mysql excluding table, exclude a mysql table, database backup mysql, mysqldump table exclude,ignore table mysql,–ignore-table

Dump mysql database excluding a table, here ‘ignoretable’  is the table that I wish to ignore.
mysqldump -u $user -p$pass –ignore-table=$database.$ignoretable $database > $backup