Support » Plugin: All-in-One WP Migration » mysql tables not properly updated

  • Resolved wimjanse


    I noticed that when I make changes to the structure of a user generated mysql-table (within the wp_ structure), and then when I export the entire website and import onto another server, which is running the old version of the website, and is having the old table structure, the table structure on this computer is not modified according the new layout during the update, but remained as is. So in fact, I end up with a broken website on the new computer.
    Is this something I can force with any settings?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Borislav Angelov



    All in One WP Migration only exports tables with current table prefix defined in wp-config.php. If you have custom tables with different table prefix, they will not included in the backup file on export. This is done on purpose, because there are WordPress installations that share same database, but they have different table prefixes.

    Thread Starter wimjanse


    For my custom tables, I do use the custom prefix. But if I change the structure of a table (ie add columns), that new structure is not migrated properly.
    I tested two cases.
    – If I create a new table on server A, which does not exist on B, the new table is created on B, both strucure and content, so This is OK.
    If the table exists already on B (in the old structure), the table modification I made on A is not propagated to B, so not OK in my view.

    Plugin Author Yani Iliev



    I think you might have used an older backup.
    The way the plugin works is like this:
    $tables = Get all the tables starting with wpdb->prefix
    Drop all $tables
    Create all $tables
    Insert the records into all $tables

    So if the table you are referring to was exported, it will first be dropped, recreated, and then records will be added to it.
    If the table structure is the same as the old one, then the backup must be using the old structure.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘mysql tables not properly updated’ is closed to new replies.