Bug #27324 mysql_install_db shows different behaviour than before

• Submitted: 21 Mar 2007 11:16
• Modified: 23 Mar 2007 12:29
• Reporter: Oli Sennhauser
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.1.15 and 5.1.16
• CPU Architecture: Any

[21 Mar 2007 11:16] Oli Sennhauser

Description:
I have a non default setup: Installing my binaries under $HOME/product/mysql-5.1.16.

Before 5.1.15 calling ./scripts/mysql_install_db worked fine.
Since 5.1.15 I get an error:

./scripts/mysql_install_db
Could not find help file 'fill_help_tables.sql' in ./support-files or inside /usr.

The I tried this:

./scripts/mysql_install_db --basedir=/media/hda3/u00/app/mysql/product/mysql-5.1.16 --datadir=/media/hda3/u00/app/mysql/product/mysql-5.1.16/data/

And got even uglier messages:

Installing all prepared tables
070321 12:14:29 [ERROR] /media/hda3/u00/app/mysql/product/mysql-5.1.16/bin/mysqld: unknown option '--skip-bdb'

Installation of system tables failed!

Examine the logs in /media/hda3/u00/app/mysql/product/mysql-5.1.16/data/ for more information.
You can also try to start the mysqld daemon with:
/media/hda3/u00/app/mysql/product/mysql-5.1.16/bin/mysqld --skip-grant &
You can use the command line tool
/media/hda3/u00/app/mysql/product/mysql-5.1.16/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /media/hda3/u00/app/mysql/product/mysql-5.1.16/bin/mysql -u root mysql

How to repeat:
cd
mkdir product
cd product
tar -xf mysql-5.1.16
cd mysql-5.1.16
./scripts/mysql_install_db

Suggested fix:
Do not know. Make behaviour like before!

[21 Mar 2007 12:29] Valeriy Kravchuk

Thank you for a problem report. Please, send URL used to download binaries of 5.1.16 that demonstrates the behaviour described.

[22 Mar 2007 14:59] Oli Sennhauser

su - mysql
mkdir -p ~/product
cd ~/product
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.16-beta-linux-i686-glibc23.tar.gz/f...
tar -xzf mysql-5.1.16-beta-linux-i686-glibc23.tar.gz
cd mysql-5.1.16-beta-linux-i686-glibc23
./scripts/mysql_install_db
Could not find help file 'fill_help_tables.sql' in ./support-files or inside /usr.

[23 Mar 2007 9:38] Oli Sennhauser

Hi Valeriy

I got the reason: ubuntu installed /etc/mysql/my.cnf and this had set all my settings to the wrong place....

Sorry for the troubles!

[23 Mar 2007 12:29] Valeriy Kravchuk

So this is not a result of bug in MySQL's code.