Differences

This shows you the differences between two versions of the page.

--- virtualizor:table-tasks-error-repair [2025/01/18 01:04] – kbadmin
+++ virtualizor:table-tasks-error-repair [2025/01/18 04:58] (current) – [2. Kedua] kbadmin
@@ Line 24: / Line 24: @@
 Login ke mysql virtualizor dengan cara
 <code>
+/usr/local/emps/bin/mysql -u root -p
+</code>
+kemudian masukkan passwordnya
+setelah login coba repair.
+<code>
+mysql> use virtualizor
+Database changed
+mysql> repair table tasks;
++-------------------+--------+----------+------------------------------------------------------+
+| Table             | Op     | Msg_type | Msg_text                                             |
++-------------------+--------+----------+------------------------------------------------------+
+| virtualizor.tasks | repair | error    | Can't create new tempfile: './virtualizor/tasks.TMD' |
+| virtualizor.tasks | repair | status   | Operation failed                                     |
++-------------------+--------+----------+------------------------------------------------------+
+rows in set (0.00 sec)
+</code>
+anda bisa perhatikan ada error pada **'./virtualizor/tasks.TMD'**
+pindahkan file tersebut ke tempat lain
+<code>
+mv /usr/local/emps/var/mysql/virtualizor/tasks.TMD  /root/
+</code>
+kemudian ulangi repair
+<code>
+mysql> repair table tasks;
++-------------------+--------+----------+----------+
+| Table             | Op     | Msg_type | Msg_text |
++-------------------+--------+----------+----------+
+| virtualizor.tasks | repair | status   | OK       |
++-------------------+--------+----------+----------+
+row in set (1.33 sec)
+</code>
+Berhasil, selamat mencoba

Layanan