From: Michael Widenius
Date: April 22 1999 8:26am
Subject: mysql_install_db fails
List-Archive: http://lists.mysql.com/mysql/2241
Message-Id: <14110.56500.715028.86171@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "bjepson" == bjepson  <bjepson@stripped> writes:

>> Description:
bjepson> 	mysql_install_db fails
>> How-To-Repeat:
bjepson> 	Compile mysql as directed on a SPARC machine running the
bjepson> 	Debian 2.1 Linux distribution (note that this is not the 64-bit
bjepson> 	ultrasparc). After you do 'make install', run scripts/mysql_install_db
bjepson> 	as directed. The following errors appear:

bjepson> Creating db table
bjepson> Creating host table
bjepson> Creating user table
bjepson> Creating func table
bjepson> Creating tables_priv table
bjepson> Creating columns_priv table
bjepson> ERROR: 1033  Incorrect information in file: './mysql/db.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/db.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/db.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/host.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/user.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/func.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/tables_priv.frm'
bjepson> ERROR: 1033  Incorrect information in file: './mysql/columns_priv.frm'

bjepson> To start mysqld at boot time you have to copy support-files/mysql.server
bjepson> to the right place for your system

Hi!

The above means probably that you have a compiler problem.
Any chance you can download egcs 1.1.2 and try this?

If not, you can try to compile MySQL with:

CFLAGS=-O1 CXXFLAGS=-O1 ./configure --with-debug

If you want to debug this;  Put a breakpoint at 'openfrm' and do
'next' until you find the error.

Regards,
Monty