From b9c4f95d3c4c9a8bb883cffef36d4aca35a5bf14 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Elan=20Ruusam=C3=A4e?= <glen@pld-linux.org>
Date: Thu, 8 Mar 2007 15:19:01 +0000
Subject: [PATCH] - detect if mysql tables creation fails by checking
 mysql.host table and leave mysql-init.sql on disk for later inspection

Changed files:
    mysql.init -> 1.109
---
 mysql.init | 20 ++++++++++++--------
 1 file changed, 12 insertions(+), 8 deletions(-)

diff --git a/mysql.init b/mysql.init
index 15140c6..c6ca55f 100644
--- a/mysql.init
+++ b/mysql.init
@@ -390,16 +390,20 @@ mysqlinit() {
 	    ln -s "$sock" /var/lib/mysql/mysql.sock
 	fi
 
-	if /usr/sbin/mysqld --bootstrap --skip-grant-tables \
-	    --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER << END_OF_DATA
-
+	cat > $MYSQL_DATA_DIR/mysql-init.sql <<-EOF
 		CREATE DATABASE mysql;
 		use mysql;
 		$(sed -e "s,@ENGINE@,$BASE_TABLETYPE," /usr/share/mysql/init_db.sql)
 		$(sed -e "s,\$hostname,$hostname,g" /usr/share/mysql/init_db-data.sql)
-END_OF_DATA
-
-	then
+		"
+EOF
+
+	ok=0
+	/usr/sbin/mysqld --bootstrap --skip-grant-tables \
+		--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER < $MYSQL_DATA_DIR/mysql-init.sql && ok=1
+	[ -f $MYSQL_DATA_DIR/mysql/user.frm ] || ok=0
+	if [ "$ok" = 1 ]; then
+		rm -f $MYSQL_DATA_DIR/mysql-init.sql
 	    ok
 	cat << END_OF_MSG
 
@@ -422,8 +426,8 @@ END_OF_MSG
 	    cat << END_OF_MSG
 Installation of grant tables FAILED!
 
-Examine the logs in $MYSQL_DATA_DIR for more information.  You can
-also try to start the mysqld demon with:
+Examine the logs in /var/log/mysql for more information.  You can
+also try to start the mysqld daemon with:
 
 /usr/sbin/mysqld --skip-grant &
 
-- 
2.44.0