Restoring on Multisite

  • Resolved John

    (@dsl225)


    10 years, 7 months ago

    Hello,

    What is the recommended way to restore the site’s sql back to the database? I have the option set to “Save the SQL content of the sub-sites in different files” and my backup has several sql files.

    But in phpMyadmin there is only one database. Do I have simply to import the main sql back? This won’t affect the other tables?

    Thanks!

    https://www.ads-software.com/plugins/backup-scheduler/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Sed Lex

    (@sedlex)

    What do you mean by main SQL ?
    You may have one database but you have a plurality of tables : the tables of sub site may be stored on different files

    I do not see your point

    Thread Starter John

    (@dsl225)

    Yes, that’s right: I have a single SQL which holds several tables in it. Some of those tables correspond to each network site.

    The backup I get contains several SQL backups, like:
    BackupScheduler_20140422153021_xxx.sql1
    BackupScheduler_20140422153021_xxx_blog2.sql1
    BackupScheduler_20140422153021_xxx_blog3.sql1
    BackupScheduler_20140422153021_xxx_blog3.sql2, and so on.

    As I don’t see “blog1” in the list above I was asking whether the first one on the list is for the main site of the network or whether it was the whole SQL containing all network sites?

    In addition, I see that some network sites have sql1, sql2, sql3, etc as in example for blog3 above – does this mean that their tables are split in several packages?

    Thanks for your help and sorry for my incomplete initial question.

    Plugin Author Sed Lex

    (@sedlex)

    the main site is included in the sql files without _blog*

    The sql files are split in different file if the size of the sql file exceed the chunck size

    Thread Starter John

    (@dsl225)

    Got it, thanks a lot for your clarification!

    Thread Starter John

    (@dsl225)

    What would be the procedure to restore the whole database? Have to re-import the sql files one by one or is there a way to re-build the database first and then import it?

    Plugin Author Sed Lex

    (@sedlex)

    You can do both : for the second solution you have to concanate the SQL files

    Thread Starter John

    (@dsl225)

    Great, thanks!
    “Concanating” is done with PhpMyAdmin?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Restoring on Multisite’ is closed to new replies.