Dear Team,
I am facing DB crash in my site. My OJS Version- 3.1.1.4
Day 1- Crash controlled_vocabs Table
Day 2- Crash sessions Table
Day 3- Crash controlled_vocab_entry_settings Table
Kindly help me
Regards
Surojit
Dear Team,
I am facing DB crash in my site. My OJS Version- 3.1.1.4
Day 1- Crash controlled_vocabs Table
Day 2- Crash sessions Table
Day 3- Crash controlled_vocab_entry_settings Table
Kindly help me
Regards
Surojit
If you’re using MyISAM tables, you can fix crashed tables in MySQL by connecting to MySQL via the mysql command and running:
repair table sessions;
and likewise for the other tables.
You can also do this via PHPMyAdmin if you like. When the command is finished you can check the table to see if it is fixed:
mysql> check table sessions;
+---------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------+-------+----------+----------+
| database.sessions | check | status | OK |
+---------------+-------+----------+----------+
1 row in set (0.09 sec)
Cheers,
Jason