vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Getting .myi errors? (https://vborg.vbsupport.ru/showthread.php?t=53369)

filburt1 05-25-2003 12:45 PM

Getting .myi errors?
 
A .myi database error (for example: "couldn't open thread.myi") usually means a corrupted database. Usually, to solve it, run the following query:
[sql]
REPAIR TABLE tablename;
[/sql]
...where tablename is the name of the .myi file, sans the .myi extension itself. If this fix doesn't work, ask your host.

The Self-Healing Database hack can fix many of these errors as well (although "fix" is relative...it's like taking pain reliever when your arm is broken rather than just healing the broken arm).

Warning! When a table gets corrupted and you run this query, often a row or two will get deleted. Unfortunately, this row can be your user account, a critical thread, etc. Let this have been a lesson to you to always back up at least daily!

Erwin 05-26-2003 12:38 AM

If your forums is large, and you don't backup at least daily if not 12-hourly, then you are asking for some serious trouble in the event of a database crash.


All times are GMT. The time now is 10:10 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01203 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete