Monthly Archives: August 2012

How to remove WordPress version number

By on August 19, 2012 5 comments

By default WordPress adds a meta tag which displays the WordPress version number that your WordPress site is running on. The version number is added just for tracking. This information can be useful to hacker to identify which version of WordPress you are running. If you are not running the latest version of WordPress the hackers can try to target the known vulnerabilities in that version to hack your site.

Note: This is just one way to identify the version. Also, even if this information is not available hackers might still try to hack it using other ways. So it is recommended that you always have the most up to date version of WordPress running.

In this post I will show you some wrong and right ways to remove this information.
Read more »

How to Find and Replace Data in MySQL

By on August 5, 2012 No comments
Recently, while migrating my blog, I had to find all the occurrences of my old URL and replace it with my URL. One way of doing this was to get a database dump, open it in a text editor and the do a find replace and the import it back. This is a 4 step process. However, I found that we can do this only in 1 step directly in MySQL using the UPDATE statement with REPLACE function.
Syntax:

UPDATE [table_name]
SET [field] = REPLACE([field],'[string_to_find]','[string_to_replace]')
Replace the [table_name], [field_name], [string_to_find] and [string_to_replace] with your specific information and then execute it.
Note: Always take a backup of your database before executing this command, in case something goes wrong. Also, it is a good idea to test the query on a local copy before running it on your production database.
Example code to replace the URL in wp_posts table

UPDATE wp_posts
SET post_content = REPLACE( post_content,  'http://www.oldurl.com',  'http://www.newurl.com' )
This above code will replace all the occurrences of “http://www.oldurl.com” in post_content field of the wp_posts table with “http://www.newurl.com”. If you want to perform the replace only on specific rows, say with id < 10, then you can use a query similar to this: 
UPDATE wp_posts
SET post_content = REPLACE( post_content,  'http://www.oldurl.com',  'http://www.newurl.com' )
WHERE ID < 10

Follow

Get every new post delivered to your Inbox

Join other followers:

%d bloggers like this: