From: <sinisa
Date: March 21 1999 6:07pm
Subject: corruptions in a db
List-Archive: http://lists.mysql.com/mysql/720
Message-Id: <14069.13662.381294.799379@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Adam Powell writes:
 > 
 > Hi... I have a problem with a database... when I try to add columns, or
 > remove columns, corruptions arise within the database that cause the load on
 > the server to go very high.  I am downloading the new version of mySQL to
 > try and solve this, has anybody else had similar problems?  And if so what
 > is the best way to solve these problems?
 > 
 > For instance, we had a char url(255) field, and when we added a new column
 > into the page_data database, seperate from URL, some of the URLs became
 > corrupted, and some other fields were randomly set to NULL - and one was
 > even set to 'hutdown of d' - which is quite bizarre.
 > 
 > Adam
 > 
 > 

Hi!

I have not yet heard of such a type of error.

Please provide more info on make and version of OS, on distribution
and version of MySQL, on the versions of C and thread libs.

Meanwhile, try to recover tables with isamchk -o tablename.

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+