table corrupted :(

Codes here !

Moderators: macek, egami, gesf

User avatar
leon
New php-forum User
New php-forum User
Posts: 36
Joined: Sat Aug 03, 2002 11:54 am

table corrupted :(

Postby leon » Mon May 12, 2003 11:01 pm

One of the tables in my mySQL database appears to have become corrupted. Attempts to access the table return an error "Can't open file: 'Survey_Answer.MYD'. (errno: 145)".

Is it possible to restore this table? Anyone can tell me what has happened and possibly if it was something I can prevent ?

Thank you !

User avatar
Oleg Butuzov
Last Samuray
Last Samuray
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Oleg Butuzov » Mon May 12, 2003 11:05 pm

i am afraid - but not=(((

User avatar
leon
New php-forum User
New php-forum User
Posts: 36
Joined: Sat Aug 03, 2002 11:54 am

Postby leon » Tue May 13, 2003 1:24 am

Pejone wrote:i am afraid - but not=(((


my error was because I never optimized the tables ?

User avatar
Oleg Butuzov
Last Samuray
Last Samuray
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Oleg Butuzov » Tue May 13, 2003 5:26 am

might be. i don know. but some times whan i copy databse file i have this error. few time i tried to fix db, but unfortunatly it was un sussex.

User avatar
Joan Garnet
Moderator
Moderator
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars
Contact:

Postby Joan Garnet » Wed May 14, 2003 10:47 am

Next time have a look at this pages before configuring a table and its column types:
http://metrodenver.org/index.php?k=3&s=7
or the official one at mysql.com
http://www.mysql.com/doc/en/Column_types.html

Maybe a column has reached value that goes further than the maximum value you entered when you configured it.
I'm not sure about it... but it could be.

The best you can do when you create tables is plan how traffic you could have and how users will interact with the table columns, specially when they can insert data.

Bye!


Return to “mySQL & php coding”

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest

cron