(Fixed) WordPress: Lost Categories and Error Table

wordpressalmost 4 weeks i’m not checking my websites using wordpress, the posting are losts and also the categories. asking to uncle google but they said to check the wp_term_taxonomi tables, but after going to phpmyadmin to check the files, i’ve found that this table was error. i can’t open it at all. the error messages is

Can’t create/write to file /tmp/ (Errcode: 28)

so this is what i’m doing to fixed all of this things :
1. Create another directory example /var/lib/mysql
2. Open your my.cnf using vi editor
3. Add or Edit :
[mysqld]
tmpdir = /var/lib/mysql
4. Restart your Mysql Server

this my my.cnf :

[mysqld]
skip-bdb
skip-innodb
tmpdir=/var/lib/mysql

it’s work now …

~rio

3 thoughts on “(Fixed) WordPress: Lost Categories and Error Table

  1. mas, salah satu website saya juga mengalami hal ini…
    tiba2 ntah dari mana, semua ketgori dan tags nya hilang…

    Tapi, saya cek di wp_term_taxonomy bisa kebuka… Untuk melihat error-nya dimana ya?
    Dugaan saya masalah saya juga berkaitan dengan folder tmp ini…

    Trims…

    1. mas punya akses gak ke hostingnya? atau ke shell script nya? kalau misalnya tidak punya aksesnya ..
      mungkin bisa request ke tempat hostingnya untuk melakukan edit pada my.cnf tersebut. atau lakukan hal2 berikut:

      1. Create another directory example /var/lib/mysql
      2. Open your my.cnf using vi editor
      3. Add or Edit :
      [mysqld]
      tmpdir = /var/lib/mysql
      4. Restart your Mysql Server

      this my my.cnf :

      [mysqld]
      skip-bdb
      skip-innodb
      tmpdir=/var/lib/mysql

      demikian mas, semoga lekas beres masalahnya. 😉

      ~Rio

Leave a Reply

Your email address will not be published. Required fields are marked *