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

[14 Jul 2003 10:04] Paul Dubois
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.
[27 Aug 2003 3:20] Michael Widenius
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
[17 Apr 2004 20:21] Steve Slater
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
[18 Apr 2004 15:42] Lenz Grimmer
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