Generally your system could return an error code with MySQL error code 134. This concern might be attributable to quite a few causes.
MySQL error code 134 = report has already been deleted (or report file crashed)
Resolution: it is advisable to restore the desk within the database
Purpose
MySQL desk is corrupted (with MyISAM as storage engine).
1.6.3 Restoring MyISAM Tables
-
tbl_name
.frm -
Cannot discover the file
tbl_name
.MYInnn
) -
Surprising finish of file
-
Recording file crashed
-
Obtained error
nnn
from desk supervisor
-
Please again up your knowledge file earlier than continuing.
-
Use myisamchk -r
tbl_name
(-r
stands for “restoration mode”). It will take away invalid rows and take away rows from the info. Create the file and re-create the index file. -
If the earlier step failed, usemyisamchk – get better safely
tbl_name
. Protected restoration The mode makes use of an previous restoration methodology that handles a number of instances This regular restoration mode doesn’t work (however is slower).
Recording
If you’d like the restore course of to go a lot sooner, here is what it is advisable to do Set values sort_buffer_size
and Variables key_buffer_size
every as much as about 25% of your free reminiscence when working Myisamchk.
-
Transfer the info file to a protected location.
-
Use a desk description file to create new (empty) knowledge and file index:
wrapper> mysql dbname
mysql> SET autocommit = 1;mysql> TRUNCATE TABLE tbl_name;mysql> exit
-
Copy the previous knowledge file to the newly created knowledge File. (Do not simply transfer the previous file to the brand new one. You wish to make a copy in case of issues.)
Essential
In case you are utilizing replication, you have to first aboutbecome her Comply with the above process as this can be a file system Operations that aren’t logged by MySQL.
-
Restore the outline file from the backup and return to Step 3. You may as well restore and revert to the index file. Step 2. Within the latter case, you have to begin with myisamchk -r.
-
If you do not have a backup, however you understand precisely what the desk appears like is created, make a duplicate of the desk in one other database. Delete the brand new knowledge file and transfer it
.frm
Description and Different folks’s index information.MYI
A database in your emergency database. It offers you one thing new Description and index information, however go away Information file.MYD
solely. Come again to the stage 2 and attempt to restore the index file.