Title: Serialized PHP data in SQL database
Last modified: August 31, 2016

---

# Serialized PHP data in SQL database

 *  Resolved [thealex626](https://wordpress.org/support/users/thealex626/)
 * (@thealex626)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/)
 * Hello!
    I faced a problem when duplicator doesn’t parse the serialized PHP data
   in the database when moving from one domain to another. As a result, I lost all
   text widgets on my site after moving it. The question I wanted to ask it: does
   Duplicator actually parse the PHP serialized data in database tables? Should 
   I use **interconnectit** script instead if I have a lot of text widgets?
 * Thank you in advance!
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153865)
 * It should, in fact it uses a subset of that script. You may need to check the
   full database scan on step 2 of the installer, under advanced options. That will
   also pickup tables that don’t enforce primary keys, it could be that the widgets
   your using don’t use them.
 * If they do use primary keys then something else seems to be causing the engine
   to not work for some reason, not really sure to be honest….
 *  Thread Starter [thealex626](https://wordpress.org/support/users/thealex626/)
 * (@thealex626)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153885)
 * Where can I find these Advanced options? I’m using the free version.
 *  Thread Starter [thealex626](https://wordpress.org/support/users/thealex626/)
 * (@thealex626)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153892)
 * Okay, I found it – in the installer.
 * But it shows only a few tables to scan. Is that normal?
 * Screenshot:
    [http://oi63.tinypic.com/9vl5q9.jpg](http://oi63.tinypic.com/9vl5q9.jpg)
 *  Thread Starter [thealex626](https://wordpress.org/support/users/thealex626/)
 * (@thealex626)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153896)
 * It works! The problem I had was because of utf8mb4 encoding in database. After
   manually replacing all utf8mb4 references to normal utf8 and utf8_general_ci 
   inside of SQL file with Notepad++, it showed me all the tables and worked. It
   even replaced the serialized data correctly.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153900)
 * Sweet! Thxs for the update, I’m sure its bound to help someone else…
 * Cheers~

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Serialized PHP data in SQL database’ is closed to new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/serialized-php-data-in-sql-database/#post-7153900)
 * Status: resolved