Been there done that. Try this:
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
Its a search and replace tool that you put in your WordPress root and just run it from mydomain.dev/searchreplacedb2.php
It fixes the serialization problem when you want to change the url:s to the live one.
Related Posts:
- How to copy data from a custom field to the post_content?
- So much data in postmeta
- What is the advantage of the wp_options design pattern?
- Remove old custom field after import
- Edit Custom Database Tables in WordPress
- importing data from non-wordpress mysql db
- How to delete custom field “suggestions” from dropdown list
- Register new user and add custom data row value for it
- Front-end update_post_meta with ajax
- Advice needed for importing custom field data and database structure
- Leader board for game on homepage
- Which is best in the following scenario : post_meta vs custom table vs parent/child posts
- Default WordPress taxonomy (Tag) – How to add a custom field to form and save it to the database
- Separate table or usermeta
- Custom User Profile Fields
- Get all posts that do not have a specific custom field without using a subquery
- Move value from one meta key to another
- Custom fields not getting saved in the databse when added to the add new user profile page
- Is there any way to get all meta and standard columns for any WordPress object after searching based on meta key and value
- Is there a better way to list all database terms alphabetically?
- Linking Custom Fields to Database Records
- How to populate custom field dropdown box based on prior selection?
- Migrating old posts to new wp, how to extrapolate infos from the post body to custom fields?
- get_posts in meta box dropdown not showing latest posts
- When creating a metabox do you have to create DB fields for the data?
- Limit of char count in WP custom fields
- Adding custom field and querying from post table
- Diamond question mark in text after migrating content
- How do I convert all custom_field php timestamps in the database to js timestamps?
- Getting and calculating averge value of custom fields of the same tag
- How To Save Data From Remote APIs To ACF?
- Retrieving and inserting data in custom fields
- I have a form with a custom button ,i want to add the field data to an database when clicking the custom button
- update_user_meta(): invisible data storage
- Populate a select box with data stored in the database?
- Updating custom fields with external data
- Download stuff after filling fields?
- Import data from arbitrary CSV to WPAlchemy meta fields
- Cannot get tags working from a WPAlchemy metabox with wp_editor()
- Dynamically create check boxes for given post titles in WPAlchemy
- Website that sells statistics
- How to create a searchable database with a single-field search box at the front end? [closed]
- Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
- Is it safe to store a user setting you don’t want the user to ever modify as a user option?
- Add custom fields to search
- How to get users by a custom field / by user meta data?
- Moving WordPress to new server: no posts found
- extend Meta Box / Document Panel
- Add multiple images to a page sidebar
- getEntityRecord without knowing the post type
- Add custom field to image editor
- Migrating WPMS from apache to IIS7 causes Database Error
- TinyMCE in Custom Metabox not loaded after upgrading from WP 3.1.4 to WP 3.2
- How to break meta values into different items and avoid duplicates?
- ajax delete value from custom field array
- How can I sort get_users() by any value (last_name, user defined fields and more)
- Custom field for default gallery
- Custom field value based on other custom field values
- Sorting posts by custom fields in meta_query
- nextgen gallery: how to get picture url by gallery id
- How to add posts through CSV or excel file in a PHP file
- Can’t display errors in attachment_fields_to_save
- Custom Field 101
- Best filter to use for modifying custom fields on a post?
- How do I query the title (or handle?) of post meta fieldset (created with Simple Fields Plugin)
- Is it preferable to use custom code to create metaboxes instead of plugins (such as ACF) and if so why? [closed]
- Function that replaces the image in the absence of the post meta
- Is there a way to set default custom fields when creating a new post?
- Add custom column for custom field
- ul list with only as many li’s as filled custom fields
- How can I output WPAlchemy repeating fields meta values in my page template?
- Is there a way to dump all registered sidebar/widget?
- How to hide post meta
- ACF Plugin How to make the customer add more fields in the post?
- Meta Box Plugin Cloned Fields – Multiple Foreach values
- get_post_meta returns 0
- Custom field bug in WordPress 3.2
- Users uploaded image and matching an id or taxonomy
- Let any visitors delete a post if they know Id nr & password?
- A query to substitute images paths in gutenberg (website migration)?
- update a custom field with the value of another existing custom field
- Post meta data not showing in frontend, until hitting ‘update’ button
- Ordering posts by custom fields (Date)
- PHP and Shortcode Combination
- Retrieving Advanced Custom Field within Shortcode Function [closed]
- How to properly get popular Posts by multiple Values
- Get custom fields when hover link of post
- WP Query multiple select form – meta_query help
- update_post_meta not working in action hook
- Group pages by custom field values
- How to create Parent-Child relation for custom fields?
- How to check if custom field exists in this widget query
- display loop only if a post meta data exist
- How do i output images from URL’s added to the same custom field key
- Add Custom field under the post title [closed]
- Check if a field is capitalized?
- Filter Query Post by Custom Fields(by date)
- Can’t sort custom column on user.php by number / meta_value_num?
- Need to call this php function inside a modal window from text widget
- Truncating characters in Advanced Custom Fields works some places but not others?