I love to use this tool, Search and Replace for WordPress Databases. It is basically a PHP script that is written for WordPress usage (but of course can be used with any database). When placed in the WordPress project, it automatically detects and loads the Database using data from wp-config.php file.
It enables you to make database queries based on regex, with a ‘dry runs’ – you will see a preview of the data that will be changed, but no real changes would be made. Also, it is serialization aware, meaning, if the variable you are replacing is inside a serialized object, it will safely be replaced, without breaking the serialization.
Setup is easy, just drop the folder in the WP root, and navigate the browser to the main PHP file. Remember to remove it afterwards.
I think you will love it as well, but remember to backup and double check before any live runs.
Related Posts:
- Manually removing revision post types
- Reset/Reorder posts ID in the MySQL wp_posts table
- How do I find which articles are missing a featured image in The WordPress database?
- What do these phpMyAdmin errors mean on my WordPress databaes?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- Restore woocommerce orders
- How to select particular month post from table and update the post status using MySQL?
- Bulk find & replace on WordPress posts/pages (minus image paths)
- SQL trigger failes with post_content
- Converting Posts to Pages
- How to change the publishing date of each posts?
- How to manually delete post from database without causing conflicts?
- When is the ‘post_content_filtered’ column in database cleared by WordPress?
- Can posts have parents?
- Where is the old post permalink slug stored?
- Separate Database Tables For Different Post Types
- MySQL Query to Retrieve Category from wp_posts
- SQL Query for getting all posts in their latest revised state
- How can I safely increase the character limit for post passwords?
- How to Group Posts by the First Letter or Number?
- Restore contents of deleted user
- How are terms connected with posts in database?
- Moving WordPress to new server: no posts found
- Search & Remove Specific Shortcode From All Posts
- Manually delete post from database
- How to force update all posts after import
- How do I write this SQL statement for Posts written in last 24 hours?
- Custom Taxonomies Incorrectly Counting Revisions?
- database columns: post_title vs post_name
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Query All users that has post
- Exporting Data from WordPress into a flat table
- Tons of Twitter rows in my database
- Can’t publish new posts
- Insert posts in two tables
- Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
- Importing New Posts from Live Site into Local Dev Site
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- How much of my site can I recover from public_html?
- How to store an extra (surrogate) ID when creating a post with wp_insert_post?
- Split WP_POST table based on post types
- Most recent post from another database
- Tags to Post-ID mysql query. Tag Search
- What structure should post_content have in the database?
- Multiples Empty Posts were created and cannot delete them
- How to delete all the content of a wordpress site without deleting the Post and pages?
- Extracting post categories
- How to modify post content?
- wp_insert_post – duration
- After database migration, posts not showing up in dashboard
- Get user categories with most posts in it
- Transferring WordPress Database – Serialised data
- Emojis replaced by ‘?’ automatically
- MySql query to get posts with all meta and terms
- WordPress Local And Live Site
- Can’t update old posts 3.5.2
- Custom order for Mysql array
- Copy post to separate database with “add_action(….)”
- List authors with the last post title and order by last post date
- When open add new post or page WordPress add post with ID=0 continuously [closed]
- wp_posts table: safely remove unused columns to save database storage
- Anyone know why wordpress converts some html entities to their numeric equivalents?
- How to Mysql select a list of posts with meta_values AND all relevant categories?
- Order posts alphabetically: how to set order=asc in mysql query?
- why there are so many posts whoes post_type is revision? will these records waste too much database space?
- Delete all drafts?
- Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
- Is it possible to use WP_Query to only pull posts with attachments?
- Get posts and include taxonomy term
- Why my wp_posts data is so huge?
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- Add field to user meta table in database when link is clicked
- update image path with words starting uppercase to lowercase chars
- How safe is it to delete old posts edits to save database space?
- Delete post revisions only for a single post
- Move posts from a non-wordpress site to wordpress
- wp_posts table extremely large
- How to Assign / Move all Deleted post to a category
- Display post number by category
- Saving Post Data in Another Database
- Queries take 120+ seconds on my large WordPress site
- Database hacked – random posts are modified
- Need to change all links in page content but not in post content
- Can’t update WordPress Page if post_content is Empty
- How do post IDs work in WordPress?
- Why when I create a new post I found 2 record related to this post into the posts database table?
- Get author posts count after excluding a category
- Update field in database for users
- Import custom database into wp and keep the post id
- why the posts queried from sql is more than those showed on the page?
- get last post’s link with SQL query
- Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
- Is there a function to get post info for any publish_status by post ID?
- query for filtering published posts?
- Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
- How Can I Always Display A Particular Post First Using WP_Query?
- Help on conditional statement to accompany wp_insert_post function please?
- MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
- Deleting post tags removes categories
- How can I globally italicize list of texts in the UI database or Posts? [closed]