Okay, I’ve been running dedicated servers for couple years now and I used to mess around with Linux boxes back in college.

Here’s an essential automatic script and a cron job you will need in order to keep your backup automatic.

Yes, if you get a dedicated server, don’t get their stupid extra $15/month for backing up your database.  (All they do is make scripts like this one and charge you for it)

You can follow this example and go spend that money on junk food.

So all you have to do is FTP your backup files.

This is way better than going into your phpMyAdmin and downloading from the web interface since the file is already ready for you to download.

Here’s how you do it:

1) Make a new file called backup.sh in your home directory. 2) Use the following syntax:

mysqldump -u[USERNAME] -p[PASSWORD] –opt [DATABASE NAME] > /root/backup/DATABASE1.sql

Here’s an example backup.sh file if you had 2 databases:

mysqldump -uUser1 -pPassword1 --opt Database1 > /root/backup/Database1.sql
mysqldump -uUser2 -pPassword2 --opt Database2 > /root/backup/Database2.sql
tar cvf /root/backup/sqlbackup.tar /root/backup/*

You can test your script by typing this:

sh backup.sh

(The mysqldump will overwrite the older file if you run this more than once)

3) If everything is working good, now you can put that script to be run once a day in your cron job.

For Fedora Core, you can edit this file /etc/cron.d/sa-update

Add the following line:

10 3 * * * root sh /root/backup/backup.sh

This will execute the script once a day at 3:10AM.

Now simply download one tar ball file whenever you feel like backing up your database.

You can probably change this a little bit and use it for many other things like backing up all your files too. (which I do)

If you have multiple servers like me, you can also automate your scripts to download backup databases to each server. That keeps things real redundant in case of server failure.

I was moving Bedzine, Keetsa, Sleepzine, Mattresszine, and Wagg.It to another server the other day and my WP-Cache kept stallin’ on me so I looked up go Google for a newer version. I found WP-SuperCache which is simply built on top of WP-Cache. Basically, the difference between the two is that the WP-SuperCache also creates a permanent page for pages that have no comments. There are some functionalities such as Lock-Down to help your server from going down in case you get Digged, Stumbled, or Slashdotted.

BTW, don’t use Aplus.Net for dedicated hosting, they had a downtime of almost 5 days! That’s worse than any shared hosting I’ve tried. The funny part is that, all our websites were down but Aplus.Net’s homepage wasnt’t. It explains how they prioritize their customers below their revenue. I’ve had similar experience with Cari.Net, our current host. But when our sites when down, their homepage went down too. Which makes another reason for them to make sure their servers up again. The downtime with Cari.Net wasn’t more than couple hours so I figure it was time for switch to Cari.Net and stop dealing with Aplus.Net. (Think about the time I wasted in moving those websites, changing DNS for the domain names, trying to cope with the new server enviroment. It’s headache and I am glad it’s stopped and our servers are purring.) We’ve got 3 dedicated servers now to run all the websites, costing us an arm and a leg every month. Order a review and help us keep this site live.

Download WP-Cache here:

Download and Install

• Remove any existing instances of WP Cache, as WP Super Cache is a drop in replacement. Don’t forget to delete the files wp-content/advanced-caching.php and wp-content/wp-cache-config.php.
• Download the newest version of the WP Super Cache plugin from the WordPress.org plugin db and follow the instructions contained in the readme.txt file. If you have installed WP-Cache before this shouldn’t be any more difficult.
• After installation, go to the WP Super Cache options page and set your desired cache time.

via ocaoimh.ie - (Funky domain name huh?)

Okay, it seems like there’s a lot of people making money just blogging including this guy, John Chow.

Check out John Chow who made $7000 already in February. Actually some of his articles are very helpful such as the ReviewMe ad you see we put up today on the sidebar.

I like how he uses terms like affiliate whores and google whores. Just seemed very new down-to-earth terms for me to understand the whole blog marketing crap.

Check out this list of google whores. Well they really are the successful googlers but the term just sounds really funny.

I wonder if John has posted an article about yahoo whores…well there’s probably not many who made enough money using Yahoo Publisher’s Network yet…

We’ve recently signed up for ReviewMe, Blog ads, and looking some new ways for blog revenue.

Hey, did you our Bizrate ad? Yes, we finally got a sponsor for the site, we are going to be able to add more servers and all! (In the past, Max’s pockets have been going downhill with lots of debt due to over-spending on dedicated servers for websites… )

Our recommended Blog advertisement route:

Blog Ads Network

ReviewMe

We tried performancing before but they’ve seem to gone haywire lately after some kind of buyout.