"SfR Fresh" - the SfR Freeware/Shareware Archive

Member "mysql-4.1.22-win32/mysql-test/install_test_db" of archive mysql-noinstall-4.1.22-win32.zip:

As a special service "SfR Fresh" has tried to format the requested source page into HTML format using source code syntax highlighting with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. That can be also achieved for any archive member file by clicking within an archive contents listing on the first character of the file(path) respectively on the according byte size field. 
    1 #!/bin/sh
    2 # Copyright (C) 1997-2002 MySQL AB
    3 # For a more info consult the file COPYRIGHT distributed with this file
    4 
    5 # This scripts creates the privilege tables db, host, user, tables_priv,
    6 # columns_priv in the mysql database, as well as the func table.
    7 
    8 if [ x$1 = x"--bin" ]; then
    9   shift 1
   10 
   11   # Check if it's a binary distribution or a 'make install'
   12   if test -x ../libexec/mysqld
   13   then
   14     execdir=../libexec
   15   else
   16     execdir=../bin
   17   fi
   18   bindir=../bin
   19   BINARY_DIST=1
   20   fix_bin=mysql-test
   21   scriptdir=../bin
   22   libexecdir=../libexec
   23 else
   24   execdir=../sql
   25   bindir=../client
   26   fix_bin=.
   27   scriptdir=../scripts
   28   libexecdir=../libexec
   29 fi
   30 
   31 vardir=var
   32 logdir=$vardir/log
   33 if [ x$1 = x"-slave" ] 
   34 then
   35  shift 1
   36  data=var/slave-data
   37  ldata=$fix_bin/var/slave-data
   38 else
   39  if [ x$1 = x"-1" ] 
   40  then
   41    data=var/master-data1
   42  else
   43    data=var/master-data
   44  fi
   45  ldata=$fix_bin/$data
   46 fi
   47 
   48 mdata=$data/mysql
   49 EXTRA_ARG=""
   50 
   51 if test ! -x $execdir/mysqld
   52 then
   53   if test ! -x $libexecdir/mysqld
   54   then
   55     echo "mysqld is missing - looked in $execdir and in $libexecdir"
   56     exit 1
   57   else
   58     execdir=$libexecdir
   59   fi
   60 fi
   61 
   62 # On IRIX hostname is in /usr/bsd so add this to the path
   63 PATH=$PATH:/usr/bsd
   64 hostname=`hostname`		# Install this too in the user table
   65 hostname="$hostname%"		# Fix if not fully qualified hostname
   66 
   67 
   68 #create the directories
   69 [ -d $vardir ] || mkdir $vardir
   70 [ -d $logdir ] || mkdir $logdir
   71 
   72 # Create database directories mysql & test
   73 if [ -d $data ] ; then rm -rf $data ; fi
   74 mkdir $data $data/mysql $data/test 
   75 
   76 #for error messages
   77 if [ x$BINARY_DIST = x1 ] ; then
   78 basedir=..
   79 else
   80 basedir=.
   81 EXTRA_ARG="--language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/"
   82 fi
   83 
   84 mysqld_boot=" $execdir/mysqld --no-defaults --bootstrap --skip-grant-tables \
   85     --basedir=$basedir --datadir=$ldata --skip-innodb --skip-ndbcluster --skip-bdb \
   86     $EXTRA_ARG"
   87 echo "running $mysqld_boot"
   88 
   89 if $scriptdir/mysql_create_system_tables test $mdata $hostname | $mysqld_boot
   90 then
   91     exit 0
   92 else
   93     echo "Error executing mysqld --bootstrap"
   94     exit 1
   95 fi