MySQL: Can not drop or create specific tblname

user-pic
Vote 0 Votes

Symptom:
Drop table shows "Unknown table"
Create table only create tblname.idb, but not tblname.frm, select the tblname shows doesn't exist

Fix procedure:
1. Stop MySQL
  service mysql stop
2. Remove ib_logfile0 and ib_logfile1
  cd /var/lib/mysql
  rm ib_logfile0 ib_logfile1
3. Remove tblname files
  cd /var/lib/mysql/dbname
  rm tblname*
4. Start MySQL
  service mysql start

Leave a comment

About this Entry

This page contains a single entry by Pank published on January 28, 2014 10:23 AM.

CSV Tips for Excel was the previous entry in this blog.

5 Hosts MySQL Cluster is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives