Databases How-To MySQL WebApps wordpress

How To Back Up WordPress with mysqldump

Here’s a quick how to:

1. Tar up the directory:

tar cvf WordPress.tar wordpress/.
bzip2 WordPress.tar

2. Dump the database.

mysqldump --user user_name --password --host --extended-insert=FALSE database_name > database_name.sql

I personally use extended-insert set to false because I often have to read the SQL.

Here is how to restore from backup:

tar zxvf
mysql --user user_name -p database_name < database_name.sql

Be sure to replace user_name, and database_name with the appropriate values for your system.

I hope this helps.

iphone wordpress

Testing Out The WordPress iPhone App

I’m driving from LA to San Francisco today. I’m trying out the WordPress iPhone app to see how much it differs from the Desktop experience.

blogging iphone Social Media Webalytics

4 Tools For Blogging on the Go

Great blogging tools make you more efficient. They can also help you drive more traffic to your site.

1 Camera+ brightens up your photos and makes them look so much better. You can share your photos on major social networks.

2 WordPress for the iPhone is a must. I’ve written posts on my iPhone and it’s a great tool. Whatever blogging software you use, make sure you find the one that works with your smart phone!

3 Seesmic for the iPhone allows you to share your blog post created on the go. If you use you can share one blog post on, facebook, myspace, friendster, flickr, tumblr, twitter, and bebo in one status update!

4 Once you’ve posted your message, it’s time to study your Google Analytics. The only iPhone app that does this for me is Analytics Apps. At $6.99 it is pricy, but if you’re on the road lots, it’ll start paying for itself.

WebApps wordpress

Testing the iPhone WordPress App

Just typing this from my iPhone. It works really sweet & is full of win.


This Post posted by ScribeFire

ScribeFire is a Firefox plug-in that allows you to post to your blog. In fact, I didn’t have to go through the WordPress interface to publish this, and used ScribeFire’s interface instead. It’s a must have plug-in if you’re a blogger.

Technorati Tags: , ,

Announcements php WebApps

Another Hackday Update: PHP unserialize doesn’t quite do it

Wow, I had to use someone’s custom unserialize code because PHP’s unserialize doesn’t quite work multi-byte strings. 🙁 Time wasted: 3 hours.

Here’s the function:

function mb_unserialize($serial_str) {
$out = preg_replace(‘!s:(\d+):”(.*?)”;!se’, ‘”s:”.strlen(“$2″).”:\”$2\”;”‘, $serial_str);
return unserialize($out);
Announcements php WebApps

Update on the WordPress Dev2Live Hackday

I know the bare minimum of what has to change in a WordPress install. Code that gets me the tables, and shows me the serializeable data in WordPress’ option settings is done.

Announcements php WebApps

A WordPress Hackday

Today, I’m going to explore looking for a solution for staging WordPress from a development environment to a production one. I’ll be posting throughout the day as “hacks” become available.

The main issue is changing serialized dev data into production data.

I’ll be in #wpdev2live .


Honorius, Lifestream and kPicasa

We are all like the Roman emperor, Honorius, who watched hoards of barbarians approach the gates of Rome. He knew that whatever Rome was was coming to an end.

The same thing can be said about Web 2.0.

If I look at the permanent hires happening right now they are happening in the iPhone app world. Zynga is still hiring like gangbusters if you got the LAMP stack and/or iPhone app experience.

As of today, looking at the TechCrunch Layoffs ticker there are about 78,000 techies out of work.

What’s a techie to do?

Yesterday, I looked at two WordPress plug-ins: Lifestream and kPicasa. I am currently helping out Conscious Fashionistas with their WordPress site.

Here’s the skinny.

Lifestream is perfect if you want to get any of these social networks onto your WordPress:

For me, having twitter and flickr is plenty.

If you know PHP, then you have the additional flexibility of being able to insert this piece of code to make your lifestream show up wherever you want:


kPicasa doesn’t have the flexibility and focuses solely on Picasa, Google’s photo service, but it’s great if you don’t want to bother with PHP and just want to get pictures from Picasa up on the web.

Anyway, as the holidays near, and you want to share pictures or microblog, these two WordPress plugins are great.

TechBiz WebApps

Google doesn’t like Word Press Pages

I put my hCard in my “About Codebelay Blog” pages, and noticed that doing a search on hcard-barce which is the DOM ID for my hCard returned 1 result. That one result was wrong.

I checked my logs for any signs that Google hit page_id=2 and to my surprise, Google didn’t crawl that page at all. In fact none of the major search engines except for PDF Bot hit it.

Is there a way to make my Word Press page with page_id in the URL more visible to search engines?