MySQL error di xampp phpmyadmin dengan tabel “inuse”

Bismillaahirrohmaanirrohiim…

Bagi yang menggunakan xampp, mungkin sudah familiar dengan database mysql dan web base phpmyadmin.

Nah, beberapa versi xampp terakhir jika saat restart komputer service mysqlnya belum dimatikan, bisa jadi saat menyalakan ulang mysqlnya corrupt, sehingga tidak bisa distart.

Info log errornya biasanya begini:

2025-03-13 11:14:57 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
2025-03-13 11:14:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2025-03-13 11:14:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2025-03-13 11:14:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-03-13 11:14:57 0 [Note] InnoDB: Setting file '\xampp8212\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-03-13 11:14:57 0 [Note] InnoDB: File '\xampp8212\mysql\data\ibtmp1' size is now 12 MB.
2025-03-13 11:14:57 0 [Note] InnoDB: Waiting for purge to start
2025-03-13 11:14:57 0 [Note] InnoDB: 10.4.32 started; log sequence number 127170117; transaction id 6459
2025-03-13 11:14:57 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp8212\mysql\data\ib_buffer_pool
2025-03-13 11:14:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2025-03-13 11:14:57 0 [Note] Server socket created on IP: '::'.
2025-03-13 11:18:53 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17964
2025-03-13 11:18:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2025-03-13 11:18:53 0 [Note] InnoDB: Uses event mutexes
2025-03-13 11:18:53 0 [Note] InnoDB: Compressed tables use zlib 1.3
2025-03-13 11:18:53 0 [Note] InnoDB: Number of pools: 1
2025-03-13 11:18:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2025-03-13 11:18:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2025-03-13 11:18:53 0 [Note] InnoDB: Completed initialization of buffer pool
2025-03-13 11:18:53 0 [ERROR] InnoDB: Page [page id: space=0, page number=206] log sequence number 127170417 is in the future! Current system log sequence number 127170135.

Setelah browsing nemu solusinya sebagai berikut:

Step 1: Copy folder "data" C:\xampp\mysql\data ke folder lain, misalnya "data-backup1".

Step 2: Copy dan replace semua file didalam folder backup C:\xampp\mysql\backup ke C:\xampp\mysql\data

Step 3: jalankan kembali mysql, sampai sini harusnya bisa distart mysqlnya. Kmd buka kembali phpmyadmin. (Setiap database jika dibuka tabel nya "inuse")

Step 4: stop kembali mysqlnya, copy file "ibdata1" didalam folder "data-backup1" ke C:\xampp\mysql\data

Step 5: restart mysql, dan lihatlah di phpmyadmin, harusnya sampai sini sudah normal, tabel sudah muncul datanya tidak "inuse" lagi.

Step 6: jika ada kegagalan, ulangi dari awal, dengan mengganti folder "data" dengan folder "backup", setelah normal, baru copy semua "folder database" dan "ibdata1" yang lama di copykan ke C:\xampp\mysql\data

Untuk database yang penting, sebaiknya sebelum restart komputer, backup databasenya dulu.

Baca Juga:   Explode string di MySQL menggunakan SUBSTRING_INDEX

Demikian, semoga bermanfaat.

Bagikan

You May Also Like

About the Author: rasupe

Leave a Reply

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