Hi,
Using Moodle 2.9, last week enabled auto backup. The platform consists 70 courses with students. Due to no space, we received database error. Thus, increased server space and the Moodle was back to normal.
After few minutes, following errors generated. HELP! needed. academy1.ifaaonline.com
Database changed
mysql> repair table user;
+------------+--------+----------+-----------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------+--------+----------+-----------------------------------------------+
| mysql.user | repair | error | Can't create new tempfile: './mysql/user.TMD' |
| mysql.user | repair | status | Operation failed |
+------------+--------+----------+-----------------------------------------------+
2 rows in set (0.00 sec)
mysql> check table user;
+------------+-------+----------+---------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------+-------+----------+---------------------------------------------------+
| mysql.user | check | warning | Table is marked as crashed and last repair failed |
| mysql.user | check | warning | Size of datafile is: 636 Should be: 584 |
| mysql.user | check | error | Keypointers and record positions doesn't match |
| mysql.user | check | warning | Found 11 key parts. Should be: 7 |
| mysql.user | check | error | Corrupt |
+------------+-------+----------+---------------------------------------------------+
5 rows in set (0.00 sec)