Support » Plugin: All-in-One WP Migration » extract and import database

  • Resolved tschweitzer

    (@tschweitzer)


    Hi
    how can I manually import the SQL database I extracted from inside a backup and get read off the SERVMASK_PREFIX_ ?

    I tried

    SET @database = “my_database_name_here”;
    SET @old_prefix = “SERVMASK_PREFIX_”;
    SET @new_prefix = “my_prefix_in_config.php_here”;

    SELECT
    concat(
    “RENAME TABLE “,
    TABLE_NAME,
    ” TO “,
    replace(TABLE_NAME, @old_prefix, @new_prefix),
    ‘;’
    ) AS “SQL”
    FROM information_schema.TABLES WHERE TABLE_SCHEMA = @database;

    thanks

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.