Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave

MySQL Error 138

When we move database from lower version to higher version of mysql, then sometimes we got mysql error regarding table

cant open OR error : Can’t open file ( errno: 138)

Then we will need to repair table using use_frm

use REPAIR TABLE … USE_FRM to recreate it as a valid MySQL 4.0 table

mysql> repair table <table name> use_frm;

This will solve problem.

Share on Twitter
Share on Facebook