Home / server / Questions / 343242
In Process
Kourosh Samia
Asked: 2011-12-22 11:43:23 +0800 CST

mysql Innodb engine disappear

  • 772

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.

mysql innodb

1 Answers

  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 !!!

    • 0