Support » Plugin: All-in-One WP Migration » Multisite in the same Database

  • Resolved khendricks


    Hello Servmask,

    First off, your product works great. More than what I was hoping for.

    The only thing I could not verify for sure is the following scenario:

    I have two environments
    #1 acceptance Blog (prefix wpacceptanceblog)
    #2 production Blog (prefix wpproductionblog)

    Both run on the same Database:
    Blog DB

    Is it possible to migrate from production to acceptance and vice versa within this same database. I want to make sure the production will not be effected.

    If so, is there anything else I should watch out for?

    Thank you in advanced,

    Cheers Kevin

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Yani Iliev


    Hi Kevin,

    Thank you for using the plugin.
    Your case is an interesting one.
    You found an edge case in the plugin. We haven’t thought about running 2 blogs in one database.
    However it is not difficult to add the feature you are requesting. I am putting it in the backlog and we will ship it with v1.6.0
    The problem of the plugin at the moment is that it will export ALL tables in the database then change the ones that are prefixed with the current WP prefix to SERVMASK prefix and on import, we will change SERVMASK prefix to the prefix of your blog.
    You may not end with a SQL error but the data can be mixed – eg your data from table X can come from wpacceptanceblog while the data in table Y from wpproductionblog.

    In the pro version, which costs $8.33, we have a database picker that lets you decide what tables in your database you want to export.

    I am sorry for the inconvenience

    Hello Yani,

    Thank you for your reply. I will look forward to version 1.6.0. Do you have an indicated release date for me?

    I will discuss buying a pro version with my client, however as they bought already several pro versions of plugins, they start to get more and more careful before buying one.

    I am normally a Microsoft consultant and therefore am a bit new to WordPress. The reason this scenario plays out for not only our client but others is Microsoft Azure.

    An MSDN account gives you access to a free of charge version of Azure with the possibility to make several websites but only includes a single database. They also support instant WordPress deployment for new websites.

    In this regard you might also find requests like these more frequent in the future. I think it’s great that you already included my request in your backlog.

    Thank you very much!

    Cheers Kevin

    Plugin Author Yani Iliev


    Hi Kevin,

    We are hoping to release the new version before March 10th.

    Yes, the pro version is useful for mid to large scale blogs where you need to often transfer your blog data from one environment to another (development -> production)
    If you are running a small blog and your data is below 512MB you should be able to use the free version of the plugin without a problem.

    We are definitely going to start supporting Azure with the next version of the plugin.

    Thank you for making us aware of this issue. I will keep you posted.

    Hello Yani,

    I haven’t gotten a notice but I saw v1.6 is available. Still the change does not seem to be in the changelog nor in de plugin.

    Are you still planning to develop said functionality for your plugin?

    Hope to hear back from you.

    Cheers Kevin

    Plugin Author Yani Iliev


    Hi Kevin,

    Yes, we are working on it.
    v1.6.0 include some urgent bug fixes and while we were working on those bug fixes we introduced some new features, thus we bumped the version from 1.5 to 1.6 and not to 1.5.1
    However, I just realised that it doesn’t match with what I’ve wrote here. We need to make a few adjustments to our process to make sure what we promise for each version is included in that version.

    We ran into a few other users who have the same use case as yours and at the moment this feature request is #2 in our list – if everything goes accordingly to our plan the next version will include it.

    Thank you and I am sorry for giving a false information.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Multisite in the same Database’ is closed to new replies.