Differences

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

--- virtualizor:table-tasks-error-repair [2025/01/18 01:01] – kbadmin
+++ virtualizor:table-tasks-error-repair [2025/01/18 04:58] (current) – [2. Kedua] kbadmin
@@ Line 11: / Line 11: @@
 akan tetapi database dengan table tasks masih error, maka kita coba cari solusi lain yaitu dengan.
-Pertama, kita cari user dan password database mysql virtualizor, dimana bisa ditemukan disini
+===== - Pertama =====
+Kita cari user dan password database mysql virtualizor, dimana bisa ditemukan disini
 <code>
 cat /usr/local/virtualizor/universal.php | grep db
 </code>
+kita catat user dan password mysql virtualizor tsb
+===== - Kedua =====
+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