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
MySQL desk is corrupted (with MyISAM as storage engine).
Cannot discover the file
Surprising finish of file
Recording file crashed
nnnfrom desk supervisor
Please again up your knowledge file earlier than continuing.
Use myisamchk -r
-rstands 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).
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.)
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
.frmDescription and Different folks’s index information
.MYIA database in your emergency database. It offers you one thing new Description and index information, however go away Information file
.MYDsolely. Come again to the stage 2 and attempt to restore the index file.