Some data is not restored from backup

  • Resolved Caged

    (@caged)


    6 years, 5 months ago

    I’ve done quite some WordPress migrations over the years and every time i notice some data is not restored.

    For example: In my theme i can tell WordPress to add a custom body class to certain pages: https://www.dropbox.com/s/0ohww6ieeahcuvh/Screenshot%202020-01-10%20at%2011.32.47.png?dl=0

    Every time i restore a backup of this site all that data is gone.

    Is this data not stored in the database? If not, where is it stored? If yes, why does this not carry over?

    Anybody else experiencing this problem with their setups? Am i missing something or am i skipping an important step in the restoration process?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 5 months ago

    What plugin or theme provides that dialog?

    What is your process to migrate a site?

    Thread Starter Caged

    (@caged)

    6 years, 4 months ago

    The theme that loads that dialog is Aeroland by ThemeMove.

    Migration process:

    1. Download copy of all files in source root directory
    2. Export SQL file from the source database via PhpMyAdmin
    3. If applicable: Export theme settings via Customizer or designated WP Admin area
    4. Upload copy of all files in destination root directory
    5. In the exported SQL file: Find and replace all instances of the old URL with the new URL
    6. Import the modified SQL file into the destination database via PhpMyAdmin
    7. In the destination wp-config.php file: Modify the database credentials
    Thread Starter Caged

    (@caged)

    6 years, 4 months ago

    In the meanwhile i read something about serialized data. Could it be that the find and replace action invalidates the serialized data after which the data gets reset?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 4 months ago

    >> In the exported SQL file: Find and replace all instances of the old URL with the new URL <<

    If you used a text editor, this is where you went wrong. You broke the data.

    Use the plugin “better search replace” to search for the old url and replace with the new one.

    Thread Starter Caged

    (@caged)

    6 years, 4 months ago

    Thanks. I already suspected that the text editor may have been the culprit. Will use Better Search Replace next time.

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

The topic ‘Some data is not restored from backup’ is closed to new replies.