From: Adam Powell
Date: March 20 1999 3:53pm
Subject: corruptions in a db
List-Archive: http://lists.mysql.com/mysql/687
Message-Id: <005e01be72e9$c6cca780$5a937ed4@adam.shout-ads.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


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