After database migration, theme mods don’t show [closed]

The problem was that one if the the serialized string lengths did not match its true string length. One of the migration steps was to change the domain name in the database SQL file with:

sed -i 's/old-domain-name/new-domain/g' db-dump.sql

One of the theme mods was a string that contained the old domain name. When it was changed to the new domain name, the length of the string was not adjusted to to match the new string length. Therefore, WordPress was unable to properly read the theme mods.

Lesson: Be careful when doing a global find and replace on the db-dump.sql file!

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. Solution for database version control and deployment?
  5. How to migrate a HTTPS WordPress installation to localhost?
  6. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  7. Migrating data between local and development server
  8. Best way to import users, post and categories from an external database
  9. Syncing local content with development / staging sites
  10. Organizing WP Pages based on old website database
  11. Presentation vs Content in WP DB-Tables
  12. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  13. Migrate a Non WordPress database to wordpress [closed]
  14. Weird issue with database migration and SSL links
  15. How to fix unchanged URLs in Database after running serialized search and replace script?
  16. Migrating database / content of non-CMS site to WordPress
  17. How do I reset a self-hosted WordPress URL?
  18. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  19. Export all content from wordpress
  20. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  21. Moving minor updates between local and live sites – just database?
  22. How to move the WordPress site Layout from test site to Production site?
  23. Merging two databases without borking it
  24. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  25. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  26. Trouble Migrating all data blog from WordPress.com to WordPress.org
  27. Copying database tables to new database
  28. Migrating from PDO using SQLite to clean new install using MySQL
  29. Migration: Copying database content to a different server
  30. Change WordPress URL in sql file via Terminal
  31. Strange characters added to the database
  32. Problem migrating to localhost
  33. WordPress url transformation script
  34. How to transfer from localHost to live but use the already existing database on the server?
  35. Image link issues after importing a database backup to my local web server
  36. Database migration issues – Error #1046 No database selected
  37. echo site_url() returns a different value than what is in the database siteurl field
  38. Migrate Users From laravel to wordpress
  39. /wp-admin not accessible after migrating to local host (no plugin issue)
  40. How to fix Uploaded to this post option to see group of images uploaded to a post?
  41. How do you enable scripts on a WordPress installation in Softaculous?
  42. WordPress site migration – locked out of admin area
  43. Malware in old website – how to migrate?
  44. WP website showing blank page after moving from subdomain to main domain
  45. WordPress Migration – Issue with admin panel changes
  46. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  47. How to edit posts/pages without making the change live?
  48. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  49. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  50. I cannot change anything in my wordpress database from within wordpress?
  51. Media library images “missing” after migrating them using SQL
  52. Restoring .sql backup results in “Error establishing a database connection”
  53. import (migration) user database to wp-users
  54. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  55. Moving database from WP 2.6 to 3.5 problem
  56. Importing Concrete5 content to WordPress
  57. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  58. Why WordPress choose data serialization over json_encode?
  59. Relaunch 4.2 utf8mb4 database upgrade
  60. Where can I find the database changes between WordPress versions?
  61. Does WordPress use the InnoDB engine for MySQL by default?
  62. $wpdb->prepare() warning in WordPress 3.5
  63. When is it appropriate to create a new table in the WordPress database?
  64. Performance tips for a large user base [closed]
  65. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  66. wp_options is GB in size
  67. Can’t update database after wordpress update from 3.8.1 to 4.4.1
  68. Database error Deadlock found when trying to get lock; try restarting
  69. update_user_meta() does not work
  70. wp_get_current_user always returns 0 continued
  71. How can i customize the export personal data file?
  72. Auto login subdomain from main domain on single sites with different DB
  73. “Error establishing a database connection” – Intermittent error on GoDaddy
  74. Importing Direct to DB – GUID Question
  75. WordPress site to be able to connect with data on local machine of user
  76. Bulk Updating Post Date in 1 day Increments
  77. SymmetricDS in dev + prod workflow?
  78. Fixing YARPP plugin FULLTEXT MySQL indexing
  79. Counting post and changing roles in mysql database. Query not code
  80. wpdb Insert unknown post data dynamic foreach loop
  81. How do I use a database in a custom theme?
  82. Deleting empty meta key values
  83. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  84. How to rerieve comments and their replies from DB
  85. Inserting data with Geometry field
  86. Export only a part of the database for migration
  87. Why am I being prompted to reinstall wordpress?
  88. What’s the easiest way to connect external database and display data on wordpress?
  89. database error WordPress move from one hosting to other
  90. update multiple user meta field based on another meta field
  91. After renaming MySQL database, I can no longer access my Blog page
  92. execute custom function on database connection error
  93. Call to a member function insert()
  94. Create a new table on the database and save parameters from a contact form
  95. How to add data from wordpress tables to new database tables you have created
  96. Creating Tables in WordPress Database
  97. Calling update_user_meta inside of another function doesn’t work
  98. How to back-up a database on IIS
  99. Where are database files of a WordPress website?
  100. Many images in wp-content/uploads folder that are not in Media Library