Backing up a WordPress Blog on GoDaddy

Posted on by
3
Share

Blogging is a great way to prepare content for the Internet without spending a lot of time worrying about the details of website administration and content formatting. But it’s easier to put content in a blog than it is to get it out of the blog for backup purposes. WordPress has a way to export the postings and comments into an XML file for local storage, but since you have to remember to do it periodically, you’re likely to lose a few postings if something goes awry on the server and you haven’t done a backup for a while. And the XML export doesn’t save the images you may have uploaded to your web host because those are not stored in the same database as the posts and comments.

I started looking around for a WordPress backup solution and was unable to find anything that looked like a good fit. WordPress posts and comments are not located on your GoDaddy web host. They are on a separate host/database that GoDaddy sets up when you install WordPress as an application. I download my website’s changed files to my local PC using a scheduled WS-FTP session. I generally use FileZilla for FTP and would like to use it instead of WS-FTP, but it doesn’t have a way to automate periodic downloads so I’m forced to use WS-FTP for my backups. WS-FTP isn’t free, but until FileZilla supports recurring automated scheduling of uploads/downloads, it’s the only way I know to do this. The FTP backup takes care of downloading my blog images and other website files but not the actual blog postings or comments.

GoDaddy has a web interface to set up cron jobs and I was pretty sure I could back up my blog’s database to the same WordPress directory that stores my blog’s theme and php files using a script to dump the database. A database dump could put a copy of the postings and comments in SQL format in a location where my WS-FTP job could find it and download it on a regular basis.

I figured others would like to know how to do this, so I’ve written up a short ‘how to’ here.

I will assume you have are using GoDaddy’s Linux hosting and have an SSH login and know your way around a Linux system. If not, you’ll need some help from a Linux expert who can understand the instructions below.

First of all, you can use a single command to perform the WordPress database backup manually, to make sure it’s working. Here is an example of mine which I store in a file called “wpbackup” located in the wordpress directory (please note, this command should all be on a single line):

mysqldump --add-drop-table -h mysqlhostname -u mysqlusername -pmysqlpassword mysqldatabasename | gzip -c > $HOME/html/wordpress/yourblogbackup.sql.gz

If you can’t remember the mysql hostname, username, password, and databasename because GoDaddy generates them for you automatically when you install WordPress as an application, you can find them all in the /wordpress/wp-config.php file. Please note that there is no space between the -p and the password. All other spaces are required. The mysqldump command takes all the data from your wordpress blog database and puts it in a SQL format that allows you to re-import it should the need arise. The “| gzip -c” compresses the database since SQL is made of plain text and it compresses pretty well, probably 4:1 or better. If you don’t want to use it, you can leave it out.

You will need to confirm that this is working properly. Just make sure it’s executable and type in “./wpbackup” to run it. Then you can do a “gzip -d” on the yourblogbackup.sql.gz file to turn it back into sql statements so you can browse the contents of the output file. Once you’re sure it’s working, then you are ready to set up the cron job. It is possible set up a cron job manually by editing the crontab file in your home directory, but GoDaddy has a web interface that allows you to set up and manage cron jobs without having to know how to edit the crontab file directly. You can see the result in the crontab file by looking at it in your home directory after you set it up if you’re curious.

Just go to the Hosting Control Center -> Content -> Cron Manager

Set up the job to make the wpbackup script execute on a regular basis. It should be done frequently enough to insure that your FTP download is getting a recent backup of the database.

With the cron job executing on a regular basis, and a scheduled FTP download of your website, the most recent content from your blog will get backed up so that should misfortune strike, you’ll be able to restore it to its original condition. The two commands to do that are:

gzip -d yourblogbackup.sql.gz
mysql -h mysqlhostserver -u mysqlusername -pmysqlpassword mysqldatabasename < yourblogbackup.sql

(please note, the mysql command should be all on one line)

If you found a better or easier way to backup your WordPress blog, please leave a comment with a link to your solution.
WP Starter Guide

Cool Surge Scam Artists at it Again

Posted on by
8
Share

Last year I wrote a blog article about a Miracle Amish Heater that generated a ton of traffic. I was even interviewed by the New York Times as a result of that article. Well, the company that brought us the Amish Heat Surge is at it again, and this time they are doing something even more despicable. They are misleading customers in their ads about a new cooler that uses ‘96% less energy than a window air conditioner’. There’s good reason it uses so much less energy than a window air conditioner, and that’s because it only has about 7% of the cooling capacity of a typical window air conditioner.

The $300 product is called the ‘Cool Surge‘ and it uses ‘glacier packs’ that you freeze and then load into the device so that a fan can blow air over the packs and presumably cool the room. Well, there’s only one problem with that approach and that is that device will actually make your house hotter, not cooler! Why? Because the energy it takes to freeze the ice packs comes from your refrigerator which exhausts the heat it removes from the water into your home. They conveniently forgot to mention this in their advertising. In fact, they say that the unit can’t be measured with a BTU rating. That is complete nonsense.

The BTU rating of this so-called cooler is absolutely minuscule compared with even a small window air conditioner. A small 5000 BTU/hr window air conditioner produces the equivalent cooling to melting about 35 lbs. of ice per hour. This cooler holds 12 lbs. of ice total. That’s about 1.5 gallons. Think about the volume of 1.5 gallons of water. You’ll be using a large portion of the space in your freezer to continually re-freeze these glacier packs. Assuming you swapped out these packs every 4 to 6 hours, which is how long they last according to the website, this device would have only about 7% of the capacity to cool a room as a window air conditioner. And, don’t forget, freezing the packs simultaneously puts all the heat removed from the water (and then some) into your home. There’s a good reason that air conditioners need to be vented to the outdoors. It’s because they need a place to dump the heat that they remove from inside your house. You cannot cool a house with a closed system like this.

I wish I could talk with the engineers who dream up these scam products just to see what they are thinking. I cannot imagine how they sleep at night because they are swindling their customers and the worst part is they must know it.

Twitter is making me a bad blogger

Posted on by
4
Share

If it can’t be said in under 140 characters, it doesn’t need to be said. At least that’s my view of the world when I use Twitter.

Sometimes I blog out of courtesy just to let people know I’m still alive. It saves them from having to make the awkward phone call to my wife to ask about me if I’ve been quiet too long. Instead, they can just check my blog and see if there’s any recent activity, and if so, then there’s no reason to disturb me or my wife by inquiring about my status.

Let’s face it, I have a lot of dangerous hobbies, for example, motorcycling, flying experimental airplanes, eating meat, and so forth, and there’s always a chance that I may not be around tomorrow and no one would know what happened to me. With Twitter, I can keep people aware of my most recent thoughts and experiences and not have to write too much. In fact, with my iPhone, I can snap a picture and thereby add virtually 1000 words to any tweet. It lets the people who know me in real life that I’m still alive. Best of all, my Twitter feed ends up over in the right hand column of this blog and so if you come here and find a stale article you’ve already read, you can always find a crumb in the Twitter feed. And that feature is making me a lazy blogger, because I find that I’m not updating my blog nearly as much as I might otherwise.

And if I ever do have anything important to say, I can blog it here and then tweet the link, thereby letting people know that I actually had something that took longer than 140 characters to say. In fact, I think I’ll tweet the link to this entry after I finish it.

You know you’re a bad blogger when you want to start every entry with, ‘Sorry it’s been so long since my last update…’ One benefit of merging your Twitter feed into your blog is that it gives readers some Twitter crumbs on which to nibble during those dry spells.

Now, where’s a Twitter app that periodically tweets my heartbeat? Better yet, where’s the app that posts my last tweet when that rate has gone to 0 for a few minutes….and what might I post in that final tweet? A picture? a URL? Perhaps it will be my whole life’s story reduced to 140 characters.

Are you one of those people who check in here every now and again to see if I’m still alive? What about you? Where may I surreptitiously inquire about your status? I always imagine, probably incorrectly, that some long lost friend or relative is reading this blog, yet I have no way of knowing. If you’re in that category, please, send me an email or call me (my contact info is up there under that link that reads ‘Contact’) and let me know you’re a reader. I’d really love to hear from you… you know… just to make sure you’re still alive. 😉

Tagged.com scam – one messed up company

Posted on by
13
Share

I got an invitation to join tagged.com today informing me someone I knew had sent me some photos. I clicked on a link to see if I could download the pictures, but the service required me to ‘register’ with tagged.com first. Well, I thought this was an inconvenience, but I didn’t want to disappoint the person who sent me the photos so I started the lengthy procedure that started out asking me for the usual username/password. But that wasn’t the only information they wanted. As I got into it, I started getting screen after screen of ‘offers’ and some that made mention of charging my phone number a sizable monthly fee for some service or other. I found the tiny ‘skip this’ button on each page and became exasperated in my quest to find said photos. I must have turned down 10 dubious offers.

The real deal breaker came when it asked for my gmail account password. Wait a minute! You want my email account PASSWORD, so you can ‘match me up with my other friends’? It was about that time that everything became painfully clear. This dirtbag company wasn’t going to show me any pictures that my friend had sent me, it simply duped her into giving her email password and they had harvested her ENTIRE ADDRESS BOOK and were sending out these invitations to everyone in it.

I completed the registration (without giving up my gmail password) and sure enough, there wasn’t even a single picture posted to my friend’s account. What a scumbag company!

Companies that pull stunts like this (Grouply is another one) should be sued out of existence and have their entire staff incarcerated. I hate when companies use a person’s goodwill to send messages out without the person’s explicit consent just to induce others who trust that person that they need to register to get some important information. Then they dupe THOSE victims into giving up their email passwords and propagate the duplicity ad infinitum.

I unregistered with this pathetic service and let them know my sentiments on the stunt they had just pulled.

Whenever you get a dubious offer via email even if it comes from a trustworthy source, you should do a search on the company’s name affiliated with the email and append the word ‘scam’. And never give out your Yahoo, Hotmail, or Gmail password to anyone. I’d have saved some time and frustration had I done a web search first on tagged.com because there are plenty of people that have called out these scammers including snopes. Hopefully, you found this posting before you wasted any time with this fraudulent operation.