Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    42

    Unanswered: Compiling MySQL mysql-5.0.45 fails on mysql_install_db

    Hi,

    I'm trying to install mysql-5.0.45 on a Debian server.

    I can compile fine with the commands:

    ./configure \
    --with-plugins=innobase,innodb_plugin \
    --prefix=/home/stephane/programs/install \
    --localstatedir=/home/stephane/programs/mysql/data

    make

    make install

    But when running the command:

    scripts/mysql_install_db --basedir=/home/stephane/programs/install/ --ldata=/home/stephane/programs/mysql/data;

    I get the following output:

    scripts/mysql_install_db --basedir=/home/stephane/programs/install/ --ldata=/home/stephane/programs/mysql/data; --verbose
    Installing MySQL system tables...
    Installation of system tables failed!
    Examine the logs in /home/stephane/programs/mysql/data for more information.

    The log file /home/stephane/programs/mysql/data/server1.err shows nothing at all.

    The log file only shows:
    [stephane@server1 install]$ tail -f ./mysql.error.log
    ERROR: 1109 Unknown table 'engines' in information_schema
    130414 21:28:01 [ERROR] Aborting
    130414 21:28:02 [Note] /home/stephane/programs/install//libexec/mysqld: Shutdown complete

    One other thing to note: I have been able to install that very same MySQL source code package on the very same server at the very same directory location some 2 months ago.
    Last edited by stephaneeybert; 04-15-13 at 08:23.

  2. #2
    Join Date
    Oct 2012
    Posts
    42
    After I removed my install directory and started from scratch, MySQL installed fine.

    Here is how I do:

    Download the mysql source mysql-5.0.45.tar.gz

    Remove the package mysql-common if any
    apt-get remove mysql-common

    Unpack and create a soft link
    ln -s mysql-5.0.45 mysql

    Go to the mysql directory
    cd mysql

    Create some directories
    mkdir /home/stephane/programs/mysql/install;
    mkdir /home/stephane/programs/mysql/install/data;
    mkdir /home/stephane/programs/mysql/install/var;
    mkdir /home/stephane/programs/mysql/install/etc;
    mkdir /home/stephane/programs/mysql/install/tmp

    Build
    Before MySql 5.5 use the command:
    ./configure \
    --with-plugins=innobase,innodb_plugin \
    --prefix=/home/stephane/programs/mysql/install \
    --localstatedir=/home/stephane/programs/mysql/install/data
    From MySql 5.5 use the command:
    cmake \
    -DCMAKE_INSTALL_PREFIX=/home/stephane/programs/mysql/install \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    -DMYSQL_DATADIR=/home/stephane/programs/mysql/install/data

    make

    make install

    Create a configuration file
    Before MySql 5.5 use the command:
    cp support-files/my-small.cnf install/etc/my.cnf
    From MySql 5.5 use the command:
    cp support-files/my-default.cnf install/etc/my.cnf

    Do the post installation
    chmod 755 scripts/mysql_install_db;
    scripts/mysql_install_db \
    --basedir=/home/stephane/programs/mysql/install/ \
    --datadir=/home/stephane/programs/mysql/install/data \
    --tmpdir=/home/stephane/programs/mysql/install/tmp
    Last edited by stephaneeybert; 04-15-13 at 12:07.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •