Ok. This thread is going to hell.
I'll try to sum up what I have done, and hope someone finds my misstake(s).
1. the database I'm exporting from is a 1.4betaX db.
2. The system was developed using the old admin site and fadmin. Fadmin was
added after develoment started.
3. I then tried to export things using the following set of actions:
1. Install midgard 1.4.1
2. cd /usr/local/mysql/var
3. killall mysqld
3a killall safe_mysqld
4. cp -R midgard midgard_clean
5. rm -rf midgard
6. cp -R OLD_Database midgard
7. chown -R mysql.mysql midgard
7a. Use OLD database blobdir !!
8. /usr/local/mysql/bin/safe_mysqld --user=mysql &
9.
mysql -u midgard -p midgard
alter table sitegroup add sitegroup int(11) not null default '0';
drop table repligard;
CREATE TABLE repligard (
id int(11) NOT NULL default '0',
changed timestamp(14) NOT NULL,
updated timestamp(14) NOT NULL,
realm varchar(32) NOT NULL default '',
guid varchar(32) NOT NULL default '',
action enum('create','update','delete') NOT NULL default 'create',
sitegroup int(11) NOT NULL default '0',
PRIMARY KEY (guid),
KEY realm(realm,id)
);
quit
10.
cd midgard-data-1.4.1 source dir
delete/comment out all delete statements in GUIDSforOLDSITE.sql
mysql -u midgard -p midgard < GUIDSforOLDSITE.sql
11. /usr/local/midgard/etc/repligard.conf
As admin/password for OLD database run repligard -m -r
12. Open /usr/local/midgard/etc/repligard.conf
blobdir="/var/www/blobs"
Make sure it matches the old DB's blob dir.
schema="/usr/local/midgard/share/midgard/repligard_withsg.xml"
<login
username="xxxxx*sitegroup_name"
password="PASSWORD"
/>
Uncomment and change from no to yes:
<replicate all="yes"/>
Save /usr/local/midgard/etc/repligard.conf
13. Open /usr/local/midgard/share/midgard/repligard_withsg.xml
Search and replace on repligard_withsg.xml
Change all occurances of type="string" to type="text"
14. cd /tmp
repligard -d -d -a -c /usr/local/midgard/etc/repligard.conf -e
SGname.xml.gz
15. gunzip SGname.xml.gz
Insert below just under:
<Database xmlns="http://www.midgard-project.org/repligard/1.4";>
<sitegroup id="ed7caaa0cd660b5d93b9d941fb08253b" changed="20010328102528">
<name><![CDATA[belcanto]]></name>
<realm><![CDATA[belcanto]]></realm>
<admingroup>924b8014f38f428f6053073990f0c450</admingroup>
</sitegroup>
Where:
sitegroup id / Equals <sitegroup>some_long_number</sitegroup> with quotes
changed / Copy the changed field of any one of the entries with quotes
name / sitegroup name
realm / sitegroup name
admingroup / Equals grp id=some_long_number without quotes
Then I import into a new, clean site with only /admin installed:
repligard -c /usr/local/midgard/etc/repligard.conf -i SGname.xml.gz
symtoms and problems:
* The root dir for my main site becomes "snippetdir", i.e. the snippet admin
page of the old adminsite.
=> what proved to have happened is that most(and sometimes NONE) of the old
sites pages are not imported.
* Sometimes the whole thing segfaults.
* No import has been complete.
I'm wondering if the problem is in the xml file. Does it have to be equal at
both ends (i.e. data -> template(repliguard_withsq.xml) -> file ->
template -> data) or should it be tailored to reflect the db in each end?
More theories and tips are wellcome.
Tarjei
PS: One thing we should consider, is maybe making some id space available
just for the admin sites. F.x. all ids in the range of 1 - 1000 are
adminsites only.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
