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.
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?
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?
