Distributed Software Systems LLC

Quick Way to Restore a MySQL Databse
mysql -p <database> < <dump file>

Install Package
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/mysql-server-5.0.33.tgz

Install Default Database
/usr/local/bin/mysql_install_db

Start Service And Set Root Password
/usr/local/bin/mysqld_safe &
/usr/local/bin/mysqladmin -u root password ‘<password>’

Start Daemon on Server Startup, Add to /etc/rc.local
if [ -x /usr/local/bin/mysqld_safe ]; then
  echo ‘MySQL’
  /usr/local/bin/mysqld_safe &
fi

Quick Way to Backup a MySQL Databse
mysqldump —opt —user <username> —password="<password>" "<database>" > <output>.dmp

Create New Database
create database <database>;

Create Administrator Account
grant all on <database>.* to ‘<user>’@'localhost’ identified by ‘<password>’;

Reset Privileges
flush privileges;

Install Package
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.0/packages/i386/mysql-server-5.0.22.tgz

Start Service And Set Root Password
/usr/local/bin/mysqld_safe &
/usr/local/bin/mysqladmin -u root password ‘<password>’

Start Daemon on Server Startup, Add to /etc/rc.local
if [ -x /usr/local/bin/mysqld_safe ]; then
  echo ‘MySQL’
  /usr/local/bin/mysqld_safe &
fi