Hello Edwin,

How do I export a slave site where the users are shared so that it can run by itself (images are specific)? I know to use the following tar command to restore the symbolic links: tar -chzf filename.tar.gz ./

How do I recombine the database for the slave so the users are all intact?

My current db structure is:

account_sites
- Tables
- Views
account_master

In this multisite there are the following four sites:

- Master
- Slave 1
- Slave 2
- Users

Thanks!

Concerning the files and folders, you effectively found the magic command that replace the symbolic links by physical files and folders.

Concerning the DB, this must be done manually as you will have to combined the table coming from several DBs.

When you export the DB of a website, PHPMyAdmin and MySQLDump, export VIEWS that must be replaced by physical data.
The syntax of a VIEW is like

CREATE VIEW <name of the view> AS SELECT ..... FROM DBName.DBTable

When you have "link" between different DBs, DBName is present.
When this is in the same DB, you just have DBTable.

What you have to do is, for each VIEWs, to export the tables where the data are physically stored. You have to follow the DBName.DBTable until you have a physical TABLE.

When done, in most case, you also have to rename the exported tables with the prefix of the slave site.


I hope this will help you

Thanks for your reply. I'll have to digest this for a while, but it may be above my skill level.