shells/mysql.nix

   1 with import <nixpkgs> {};
   2   mkShell {
   3     buildInputs = [ mariadb ];
   4     shellHook = ''
   5       export MARIADBHOST=$PWD/mysql
   6       export LANG=en_US.UTF-8;
   7       export LOCALE_ARCHIVE=${glibcLocales}/lib/locale/locale-archive;
   8       export MYSQL_UNIX_PORT=$MARIADBHOST/mysql.sock
   9       mkdir -p $MARIADBHOST
  10       cat > $MARIADBHOST/my.cnf <<EOF
  11       [mysqld]
  12       skip-networking
  13       datadir=$MARIADBHOST
  14       socket=$MARIADBHOST/mysql.sock
  15       EOF
  16       echo 'Initializing mysql database...'
  17       mysql_install_db --defaults-file=$MARIADBHOST/my.cnf --datadir=$MARIADBHOST --basedir=${mariadb} > $MARIADBHOST/LOG 2>&1
  18       mysqld --defaults-file=$MARIADBHOST/my.cnf --datadir=$MARIADBHOST --basedir=${mariadb} --pid-file=$MARIADBHOST/mariadb.pid >> $MARIADBHOST/LOG 2>&1 &
  19       finish() {
  20           mysqladmin shutdown
  21           rm -rf "$MARIADBHOST";
  22       }
  23       trap finish EXIT
  24     '';
  25   }
  26