Loading...
 

UsersReplication

scripted users replication

Script used to replicate users database from tikiwiki.org to doc.tiki.org

Copy to clipboard
#!/bin/sh DBHOST="localhost" DBNAME="tikiwiki" USERTABLE="users_users" USERGROUPTABLE="users_usergroups" DBUSER="***" DBPASS="***" MYSQLDUMP="/usr/bin/mysqldump" MDOPTIONS="-h$DBHOST -u$DBUSER -p$DBPASS" USERSOPTIONS="--add-drop-table" GROUPOPTIONS="-t -w groupName='Registered'" GROUPOPTIONSDEV="-t -w groupName='Developers'" WORKDIR="/home/mose/var/tikidumps" OLDIR=`pwd` cd $WORKDIR rm -f tikidump.sql.* 2&> /dev/null $MYSQLDUMP $MDOPTIONS $USERSOPTIONS $DBNAME $USERTABLE > tikidump.sql $MYSQLDUMP $MDOPTIONS $GROUPOPTIONS $DBNAME $USERGROUPTABLE >> tikidump.sql $MYSQLDUMP $MDOPTIONS $GROUPOPTIONSDEV $DBNAME $USERGROUPTABLE >> tikidump.sql bzip2 tikidump.sql scp -qp tikidump.sql.bz2 doc.tiki.org:~/ cd $OLDIR


Page last modified on Friday 20 September 2019 17:02:56 GMT-0000

Upcoming Events

1)  21 Mar 2024 18:00 GMT-0000
Tiki Roundtable Meeting
2)  25 Mar 2024 17:00 GMT-0000
29th anniversary WikiBirthday (With Ward Cunningham)
3)  18 Apr 2024 18:00 GMT-0000
Tiki Roundtable Meeting
4)  16 May 2024 18:00 GMT-0000
Tiki Roundtable Meeting
5)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
8)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9) 
Tiki birthday
10)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting