mysql Innodb engine disappear

Question

I had to change the tmpdir directory from /tmp to /db/tmp/ folder due to the fact I didn't have enough space. When I changed my path and I ran SHOW ENGINES; I got below result;

1. ARCHIVE
2. MRG_MYISAM
3. CSV
4. MYISAM
5. MEMORY

But, when I changed the directory back to /tmp my Innodb engine came back. SHOW ENGINES;

1. ARCHIVE
2. MRG_MYISAM
3. CSV
4. MYISAM
5. MEMORY
6. InnoDB

Does anyone know why MySQL is acting strange like that? This is a show stopper for me and causing my production server to crash.

Answer 1

You should add the following to /etc/my.cnf

[mysqld]
tmpdir=/db/tmp

then service mysql restart (For tmpdir, restart is required)

Also, run this in Linux just in case:

$ chown mysql:mysql /db/tmp
$ chmod 777 /db/tmp

Give it a Try !!!