:: toxpenguin ::

:: setup backup mysql db on crontab [ linux: ~ ]# crontab -e * 2 * * * mysqldump -u MYSQLUSERNAME -pPASSWORD --host=localhost --add-drop-table DATABASENAME | gzip -9 > /home/backup/FILEBACKUP_`date --iso-8601`.sql.gz

:: what is please take a look at this. :: download berkeley db [ linux:download ] # wget http://download.oracle.com/berkeley-db/db-4.8.24.tar.gz [ linux:download ] # tar -xzf db-4.8.24.tar.gz :: build/compiling berkeley db [ linux:download ] # cd db-4.8.24/build_unix/ [ linux:~/db-4.8.24/build_unix ] # ../dist/configure [ linux:~/db-4.8.24/build_unix ] # make && make install [ linux:~/db-4.8.24/build_unix ] # echo '/usr/local/BerkeleyDB.4.8/lib/' >> /etc/ld.so.conf [ linux:~/db-4.8.24/build_unix ] # ldconfig :: links + googlelinux

:: what is please take a look at this. :: installing dependency package [ root:mysql-5.1.37 ]# yum install gcc gcc-c++ make libtool automake libtermcap-devel :: download mysql-5.1.37 source [ root: ~]# mkdir download [ root: ~] # cd download/ [ root:downlad ]# wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.37.tar.gz/from/ftp://ftp.inria.fr/pub/MySQL/ [ root:downlad ]# tar -xzf mysql-5.1.37.tar.gz :: build and install [ root:downlad ]# cd mysql-5.1.37 [ root:mysql-5.1.37 ]# groupadd mysql [ root:mysql-5.1.37 ]# useradd -g mysql mysql [ root:mysql-5.1.37 ]# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-pthread [ root:mysql-5.1.37 ]# make && make install :: configuring mysql [ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysql_install_db --user=mysql [ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysqld_safe --user=mysql & :: testing [ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysql Welcome to the MySQL monitor. Commands end with ;