Performancing Metrics

Archive for May, 2004

WP Plugin: Moody

This WP 1.2 plugin adds a mood icon to the beginning of each of your entries.

Categories: WordPress Plugins

Blogger Reloaded: The Way It Should Have Been

A nice
article
on Blogger, Google’s blogging system. If you’re searching for a blog home this is a good article to acquant yourself with Blogger.

Categories: Blogger News, QuickLinks

WP Plugin: Comment Killer

This WP plugin will delete all comments that get flagged for moderation, automatically.

Categories: WordPress Plugins

The Road Ahead

State of the union address by WP developer Matt Mullenweg. Several bug fix and new feature releases may come before multi-blog capabilities are released. This from the WordPress Development Blog.

Categories: Blogging Sense, QuickLinks

Back It Up Or Lose It!

If your weblog uses a mySQL database to store all your data then chances are at some point in time it’ll get corrupted or damaged beyond repair. Imagine having a year or two’s worth of entries, links, and comments disappear in an instant.

Thankfully, backing up your database is easy and can be automated so you don’t have to worry about it anymore. I’ll show you the quick and easy way to create an automated daily backup of your mySQL database.

First open a text editor and add the following:

#!/bin/bash

mysqldump –user=”Database Username” –password=”Database Password” –all “Database Name” | gzip > “Full Path Where You Want Backup Saved”-`date +%Y%m%d`.gz

You can add multiple lines each with different database names if you want to dump multiple databases on your server.

The mysqldump command is used to dump or copy a database. By not indicating which table to copy we will default to dumping all the tables in the database. Be sure to fill-in your database username, password and the name of the database. I used quotes only to point out where you need to make changes. Do NOT use the quotes. The gzip command says we should zip up the database for economy purposes. Finally you need to add the full path to the directory where you want the dumps kept. The file name will be in the format of databasename-yymmdd.gz.

Save this text file as mysql_dump.bsh and upload it in ASCII mode to the root of your server. Now you need to create a cron job to tell the server to execute the above file at a designated time. If you have a cron tab manager in your webpanel, this will be easy. I have mine set to

0 6 * * * /path/to/your/mysql_dump.bsh

This will back up my database every day 6 AM.

If you do not have cron built into your webpanel then you will need to set it using your telnet client. First open another file with your text editor and add the following on the TOP line:

0 6 * * * /path/to/your/mysql_dump.bsh

Hit return to create an empty line below. Now save the file as cron.txt. Upload in ASCII mode to the root of your server. Log into your server via telnet. At the command prompt type

crontab cron.txt

crontab -l (where -l is a lowercase L)

Your finished. Be sure to create the directory off your root that you’re storing your back-ups in. FTP into your server the next day to verify that a backup copy was created. Your risk for data loss is now no more than 24 hours. If you don’t post much to your blog then maybe dumping your database once a week is appropriate. This will depend on your circumstances.

I hope this has been helpful in detailing one way of automating data backups on a mySQL database. Thanks to Webmaster-Central for the reminder on the crontab commands.

Categories: Blogging Sense

WP Plugin: Memberlist

The first WP 1.2 plugin by PHP-Princess.net was released today. Memberslist prints out a list of members of a group blog and their post count.

Categories: WordPress Plugins

Pay Per Word

Apropos of Something? Six Apart announces more changes to Movable Type license

Somebody has a sense of humor about the whole MT licensing fiasco.

Categories: Movable Type News

Blogs of The Screen Savers

Here’s a list of blog links for all your favorite Screen Saver crew members including Leo Laporte, Sarah Lane, Dan Huard, and Kevin Rose.

Categories: Blogging Sense, QuickLinks

WP Hack: Nicer Archives

Mark at Weblog Tools Collection has a WP archives hack to give you a sortable list of archives. You can sort on date and category and filter by author and year. I have it in use here at Blogging Pro.

Categories: WordPress Hacks

WP Plugin: Update Notify

I found here a WP Plugin that will notify an array of e-mail addresses whenever you post a new entry to your blog. This is bare bones as you have to hard code the e-mail addresses into the plugin.

Categories: WordPress Plugins

Content


Receive the top stories from BloggingPro and the Splashpress Media network every week, right in your Inbox. Relevant and timely content is yours for FREE!