Category Archives: MySQL

MySQL

Restore MySQL Database

By Chris Koehler | Published: May 26, 2007
Quick Way to Restore a MySQL Databse mysql -p <database> < <dump file>
Posted in MySQL | Leave a comment

Install MySQL 5.0 on OpenBSD 4.1

By Chris Koehler | Published: May 23, 2007
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
Also posted in 4.1 | Leave a comment

Backup MySQL Database

By Chris Koehler | Published: May 6, 2007
Quick Way to Backup a MySQL Databse mysqldump —opt —user <username> —password="<password>" "<database>" > <output>.dmp
Posted in MySQL | Leave a comment

Create New MySQL Database And Assign Administrator

By Chris Koehler | Published: May 2, 2007
Create New Database create database <database>; Create Administrator Account grant all on <database>.* to ‘<user>’@'localhost’ identified by ‘<password>’; Reset Privileges flush privileges;
Posted in MySQL | Leave a comment

Install MySQL 5.0 on OpenBSD 4.0

By Chris Koehler | Published: May 2, 2007
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
Also posted in 4.0 | Leave a comment

  • 4.0 (5)
    4.1 (3)
    CentOS (4)
    FastCGI (4)
    Lighttp (3)
    Linux (2)
    MySQL (5)
    Network (1)
    PHP (2)
    Rails (4)
    Ruby (6)
    S3 (1)
    Search Engine Optimization (1)
    Unix (2)
    VMWare (2)
    Web Services (2)
    WordPress (1)

    WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

  • Categories

  • Recent Posts