Improve your WordPress installation with SQL hacks

July 29, 2010 | No Comments Yet

Jean-Baptiste Jung shares how you can perform very useful tasks and tweaks for your WordPress blog with the use of database SQL queries. Database manipulation may be a bit advanced for the average WordPress user, but for those who are curious, this article is a great start as the tutorials are not really intimidating at all.

Here’s the shortlist:

  1. Creating a Backup of Your Database
  2. Batch Delete Post Revisions
  3. Erase 5000 Spam Comments in a Second
  4. Change the Post Attribution
  5. Manually Reset Your Password
  6. Change Your WordPress Domain Name
  7. Display the Number of SQL Queries on Your blog
  8. Restore Your WordPress Database

View other WordPress posts on Smashing Magazine here.

Leave a Comment | Tags: , , , ,

More than a dozen useful WordPress database queries

March 1, 2010 | No Comments Yet

Secure, clean up, and optimize your blog with 10 “life-saving” SQL queries from Cats Who Code. Most of them are short and should work by simply copying & pasting them into your database manager. Here’s what you can do:

  1. Manually change your password
  2. Transfer posts from one user to another
  3. Delete post revisions and meta associated to those revisions
  4. Batch delete spam comments
  5. Find unused tags
  6. Find and replace data
  7. Get a list of your commentators emails
  8. Disable all your plugins at once
  9. Delete all tags
  10. List unused post meta
  11. Disable comments on older posts
  12. Replace commentator url
  13. Replace commentator email adress
  14. Delete all comments with a specific url

The article also recommends an SQL WordPress plugin so you don’t have to go anywhere else to execute the queries. If you’re not familiar with SQL, the best way to learn is by example! As a precautionary measure, however, make sure to have a database backup ready before doing any database manipulation.

Leave a Comment | Tags: , , , , , , ,

Plugin problems? Try these steps

November 3, 2009 | No Comments Yet

Don’t panic! Daily Blog Tips has a list of things to do when a WordPress plugin you installed suddenly stops working or breaks your site.

  1. Try to de-activate the plugin
  2. Rename the plugin via FTP
  3. Delete the plugin via FTP
  4. De-activate all the plugins via PHPMyAdmin

There are several ways to disable your plugin and it will depend on how “broken” the situation is. The higher the number the more drastic the measure. The concept should apply to themes as well—try deactivating using the WordPress admin first, then try it through your FTP client, and so on.

Good luck!

Leave a Comment | Tags: , , , , , , ,

IntenseDebate reopens after Automattic acquisition, new WordPress plugin available

November 15, 2008 | No Comments Yet

IntenseDebate reopens after going invite-only since its acquisition by Automattic. So for those who haven’t signed up for an account, now you can.

And of course, they’ve made it especially easy to use for WordPress users with a new beta plugin, with the following features:

  • Two-Way Comment Sync (comments are saved both in your WordPress database and the IntenseDebate server)
  • Admin Panel Integration
  • Search Engine Optimization
  • Trackbacks
  • Profile Sync
  • Post Settings

And more:

Can’t wait to get hold of all the great commenting features included in WordPress 2.7? Get IntenseDebate now!

Leave a Comment | Tags: , , , , , , , , ,

WordPress Plugin: WordPress Exploit Scanner

June 27, 2008 | No Comments Yet

With all the talk about WordPress security vulnerabilities, every bit of protection helps. The WordPress Exploit Scanner plugin does just what it says: it looks for any suspicious behavior in your WordPress files and database tables.

This WordPress plugin searches the files on your site for a few known strings sometimes used by hackers, and lists them with code fragments taken from the files. It also makes a few checks of the database, looking at the active_plugins blog option, the comments table, and the posts table.

It also allows the blog owner to search for whatever string they like which could come in handy when new exploit code is used in a hack.

Download WordPress Exploit Scanner

Leave a Comment | Tags: , , , , , , ,

Moving Your WordPress Blog From One Host to Another

March 5, 2008 | No Comments Yet

We’ve changed URLs from WordPress.PH to WordPressPhilippines.org. So now if you’ll be visiting the old URL, you’ll end up here—hopefully instantly. It was a pretty painless process, which is one of the strong points of having a WordPress-powered site. Here are some pointers when moving your WordPress installation from one server to another:

Backup

There is not one word more important than “backup” when we talk about websites. (Computers in general, actually, but that’s another matter altogether.) You should be backing up your files regularly, but this time make one final backup before the move. Remember, you need to backup the database in which all your posts are stored and you need to backup the files which are used to run your website.

Restore

Restoring your database and files is the converse of backing up, with one difference: you have to update your account details like the database name, database user, database password, and the server path in several places for your new site to work properly.

  1. Create a new database which will hold your old data. It can be a new database name, database user, and database password—or not. Just remember the database details for later on.
  2. Import your data to the new database.
  3. Enter your new database details into your wp-config.php file—if you have changed them.
  4. Upload your site files to your new server.

Find and Replace

Because the old WordPress Philippines URL is embedded within our blog posts and comments, we had to look for every single one and change each to the new URL. Doing it manually inside a database environment is tedious and scary, depending on your expertise:

  1. Replace: old server path with new server path in wp_options
  2. Replace: old URL with new URL in wp_posts, wp_comments, wp_options, etc.

You can skip the 2nd step and do it later using the Search and Replace plugin, once your site is working properly.

Redirect

Tell Google and other search engines you’ve moved with two steps. First, edit your .htaccess file and add this:

redirect 301 / http://www.yournewsite.com/

Second, open your robots.txt (or create one if non-existent) and enter this:

User-agent: *
Disallow: /

Notify

Finally, let your friends know you’ve moved. They’ll probably notice the change of URL because of the redirect, but a letting them know won’t hurt. If you’ve submitted your site to pinging services and blog directories, be sure to change the URLs there as well.

Consider this a new opportunity to “relaunch” your blog.

Leave a Comment | Tags: , , , , ,