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]
- How to use a custom field with add_rewrite_rule()?
- what would be a good example of a php dynamic code to display contents of textarea?
- want to add video upload option for front end user
- 4 Unique Random Posts based on Custom Field Values
- Populate custom post type/custom fields from an external database
- to create a custom post type with additionnal url field such as link to social network and an email field
- Automatically convert standard posts with custom fields to custom post types
- Create Meta boxes dynamically
- Custom field group on page
- How to save array option as text and not integer?
- Outputting custom field on home.php not outside of blog list
- Custom Fields Not Working In Footer
- How to delete attachments associated with custom field type when post property changes? [closed]
- How to repeate custom field group with bulk image field
- Load one page with parent and child pages
- I cannot change anything in my wordpress database from within wordpress?
- Output Custom Field value to shortcode
- Update custom table on metabox POST
- Why can’t I get the correct post permalink
- Get link picker custom field to show only if field exists
- PHP and Shortcode Combination
- Use a different catalog image than the featured image
- Sub Field of File Field
- ACF – Compare user and post data
- Login Api with Meta_key and Meta_value
- ACF plugin and field update
- Advanced Custom Fields deleting some code and adding code for a slider
- Save input form on custom field
- How to add custom fields to images for image source text and URL
- Counting number of images from loop
- Page template is missing fields or is invalid when I updating the template
- User custom meta delete by serialised key value
- Metabox value for post loop?
- Adding fields to attachment – only shows when inserting new attachments
- Order categories by sum of custom fields
- how to modify a field’s size in a metabox : ROWS height, and scroll control?
- Saved Post Meta Array Returns as String
- How to add content with a filter when there’s no content in the editor
- Login_form add to top of form rather then bottom
- meta_query ‘compare’ => ‘!=’ not working
- Advanced Custom Fields from Category – IF statement
- Check for meta data before it is published
- Query Multiple meta
- If metabox fields has content display content
- Stop truncation of shortcodes in custom text fields?
- Delete custom meta
- custom field images do not display until page save
- How to check custom fields from functions.php
- Save custom post data outside of default post form
- display custom media folders to wordpress media popup
- Should I store arrays in custom fields or create custom tables?
- Get custom field outside wordpress loop on new php page
- Retrieving Advanced Custom Field within Shortcode Function [closed]
- Query Posts based on custom field value
- How to format the various types of custom fields?
- Problem saving meta data
- How to properly get popular Posts by multiple Values
- Admin – Search Events by a custom field