MySQL Bugs: #843: mysql_install_db does not find mysql_create_system

Bug #843	mysql_install_db does not find mysql_create_system_tables
Submitted:	14 Jul 2003 10:04	Modified:	18 Apr 2004 15:42
Reporter:	Paul DuBois	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	4.1.1	OS:	Linux (Linux (at least))
Assigned to:	Lenz Grimmer	CPU Architecture:	Any

Description:
After installling 4.1.1 into a basedir of /var/mysql/40101, I did the following:

cd /var/mysql/40101
./bin/mysql_install_db

Which resulted in:

Installing all prepared tables
bin/mysql_install_db: line 194: /var/mysql/40101/share/mysql/mysql_create_system_tables: No 
such file or directory
ERROR: 1046  No Database Selected
ERROR: 1046  No Database Selected
ERROR: 1046  No Database Selected
ERROR: 1046  No Database Selected
ERROR: 1046  No Database Selected

It appears that mysql_install_db wants to find mysql_create_system_tables
in $pkgdatadir (BASEDIR/share/mysql on my system).
However, mysql_create_system_tables is installed in BASEDIR/bin.

How to repeat:
Run mysql_install_db after installing 4.1.1.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

This was fixed by vva some time ago

FYI, looks like this carried over into the source rpm as well. 

MySQL-4.1.1-0.src.rpm

The mysql_create_system_tables entry is missing from the spec file. Works fine after adding it.

Steve

Yes, the source RPM has been fixed as well: 
 
* Fri Dec 05 2003 Lenz Grimmer <lenz@mysql.com> 
 
- added missing file mysql_create_system_tables to the server subpackage