30 Jul 10 Backup MySQL databases automatically on your VPS

A nice bash script from SourceForge to take daily, weekly and monthly backups of your MySQL databases.


– Backup mutiple databases

- Single backup file or to a seperate file for each DB

- Compress backup files

- Backup remote servers

– E-mail logs to you

- More…

Here are the steps to run this script on your VPS/Dedicated server:


24 Jul 10 WordPress plugin upgrade on Linode VPS

After migrating WordPress from shared hosting to Linode VPS,  I noticed that it needs FTP login to install or upgrade plugins/themes from the Dashboard. This really bothers me since I am too lazy to do this manually.  I thought there should be a solution in Google, however after two days of research, I just couldn’t find one that I can use.  Suddenly, I read someone in Linode forum said he fixed the problem on Debian box by changing the ownership to www-data. So, I realized that I can do the same on my CentOS

cd /var/www/
chown -R apache.apache public_html

* This command will change the ownership of all files/folders recursively under current directory to apache.

WordPress error:

Connection Information

To perform the requested action, WordPress needs to access to your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.