What does "errno: 145" mean in MySQL? — OZONE Asylum, home of the Mad Scientists

FAQ

What does "errno: 145" mean in MySQL?

This page's ID: 5391

You are editing "What does "errno: 145" mean in MySQL?"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	If you get an error like: [quote] Can't open file: 'something.MYD'. (errno: 145) [/quote] The it seems like that the table 'something' has become corrupted. There are a number of fixes that can be done from within MySQL. You can use SQL (which for the record worked like a dream for me): [quote] REPAIR TABLE something [/quote] or from the command line: [quote] myisamchk -r something [/quote] If that doesn't work and you've looked into the help (through the command line or through the manula - see links below) and it is non-essential then delete it and reconstruct it (in my research for this problem it does seem like the error commonly affects a table used for storing sessions and so getting rid of this will just mean that everyone will have to log in again) - if it is vital then now is the time that you thank your lucky stars that you have been making regular backups of your database...... You have been making backups haven't you? ----------------------- Relevant links: [url=http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html]Corrupted MyISAM Tables[/url] - from the MySQL manual [url=http://www.geocrawler.com/archives/3/3222/2002/5/0/8713076/]MySQL problem[/url] [url=http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=216590;]How to use myisamchk?[/url] [url=http://www.gossamer-threads.com/forum/Gossamer_Forum_C7/Products_C7/Discussion_F22/cant_find_file_gforum_Session.MYD_P212208/]cant find file gforum_Session.MYD[/url] [url=http://www.gossamer-threads.com/forum/DBMan_SQL_C11/Products_C11/Discussion_F15/Login_Error_-_Cant_login_P210760/]Login Error - Can't login[/url] ----------------------- Relevant notes: As of the time of writing this FAQ was ranked number 3 at Google for the terms [url=http://www.google.com/search?q=mysql+errno%3A+145]mysql, errno:, 145[/url]. _________________ [internallink=4626]Emperor[/internallink] [small][i](Added by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Mon 04-Nov-2002)[/i][/small] [small][i](Edited by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Wed 04-Dec-2002)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu