Title: Restoring on Multisite
Last modified: August 21, 2016

---

# Restoring on Multisite

 *  Resolved [John](https://wordpress.org/support/users/dsl225/)
 * (@dsl225)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/)
 * 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://wordpress.org/plugins/backup-scheduler/](https://wordpress.org/plugins/backup-scheduler/)

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

 *  Plugin Author [Sed Lex](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834688)
 * 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](https://wordpress.org/support/users/dsl225/)
 * (@dsl225)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834693)
 * 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](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834702)
 * 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](https://wordpress.org/support/users/dsl225/)
 * (@dsl225)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834704)
 * Got it, thanks a lot for your clarification!
 *  Thread Starter [John](https://wordpress.org/support/users/dsl225/)
 * (@dsl225)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834772)
 * 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](https://wordpress.org/support/users/sedlex/)
 * (@sedlex)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834773)
 * You can do both : for the second solution you have to concanate the SQL files
 *  Thread Starter [John](https://wordpress.org/support/users/dsl225/)
 * (@dsl225)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834774)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/backup-scheduler_f8f7f7.svg)
 * [Backup Scheduler](https://wordpress.org/plugins/backup-scheduler/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/backup-scheduler/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/backup-scheduler/)
 * [Active Topics](https://wordpress.org/support/plugin/backup-scheduler/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backup-scheduler/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backup-scheduler/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [John](https://wordpress.org/support/users/dsl225/)
 * Last activity: [12 years, 1 month ago](https://wordpress.org/support/topic/restoring-on-multisite/#post-4834774)
 * Status: resolved