MySQL

MySQL database, utils, tools, tip and trick

Auto backup Drupal based websites to Amazon S3

I am running some Drupal based websites. I had to spent much of time for backup my websites daily/weekly. After i moved the websites to VPS and Dreamhost, i have ssh access so i wrote a small script to backup websites databases and user uploaded file to Amazon S3 automatically. The script is executed via cron tab daily. 

Improving Drupal's Performance with Quercus and Jetty (PHP in Java)

Quercus is Caucho Technology's 100% Java implementation of PHP 5 released under the Open Source GPL license. Quercus comes with many PHP modules and extensions like PDF, PDO, MySQL, and JSON. Quercus allows for tight integration of Java services with PHP scripts, so using PHP with JMS or Grails is a quick and painless endeavor. (Excerpted from Quercus)

Backup MySQL databases automatically

AutoMySQLBackup is a great script that help us backup MySQL databases automatically. It can run thru cron job in or manually. It is easy to setup and make it works. I have just get it works only 5 minutes. The script uses mysqldump to backup MySQL databases so make sure you have it at your linux server/vps.

It is an open source/freeware so you are free to place it at your server/vps to backup your MySQL databases daily, weekly, monthy or manually.

AutoMySQLBackup features

How to import big MySQL database

 If you have some MySQL database files that bigger than 100MB, it is difficult to upload and import via phpmyadmin. Please use bigdump at http://www.ozerov.de/bigdump.zip it is the best tool to import big database files.

Compiling and Installing MySQL on Linux/CentOS

Download MySQL Source Code from http://dev.mysql.com/downloads/

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
shell> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> bin/mysqld_safe --user=mysql &

----
yum install ncurses-devel
yum install gcc gcc-c++