roughly follow
/var/www/groovix/common/doc/groovix-server-installation-from-scratch.txt

stop at pactime install


#######################################################
#######################################################
if not setting up new database,
#######################################################
cd /var/www
cp groovix/cmon/includes/config.php groovix-new-server/cmon/includes/config.php
###################################################


#######################################################
#######################################################
# might want to set up completely new database, if so:
#######################################################
use different version or prefixes during pactime setup
start to set up cmon but stop after
mysql -u gxu_XXXX -pXXXXXX gxdb_XXXX < ./howto.init.status.mysql

then re-import data from old server.

cmon pages and maps

#mysqldump --no-create-db --no-create-info  -u cgu_albany -pcgpw_x cgdb_albany pages > pages.sql ;
mysqldump  -u cgu_albany -pcgpw_x cgdb_albany pages > pages.sql ;
mysql -u gxu_albany -pgxpw_x gxdb_albany < pages.sql

#mysqldump --no-create-db --no-create-info  -u cgu_albany -pcgpw_x cgdb_albany maps > maps.sql ;
mysqldump  -u cgu_albany -pcgpw_x cgdb_albany maps > maps.sql ;
#move things around if sizes have changed:
perl -pi -e 's/left:(\d+)px/"left:".int($1*1.50)."px"/eg;s/top:(\d+)px/"top:".int(($1*1.05)-100)."px"/eg;' maps.sql ;
mysql -u gxu_albany -pgxpw_x gxdb_albany < maps.sql


if data format has changed might need to carefully export/import

must  carryover settings for global time defaults, special users,
on old server/db:
mysqldump --complete-insert --no-create-db --no-create-info -u ptu_ncrl904 --password=pX -h localhost ptdb_ncrl904 settings --where 'id NOT LIKE "guest%" ' > /tmp/settings.sql

#might have to edit .sql file to change table names, etc.
# change settings to pac_settings

on new server/db:
mysql -u gxu_ncrl --password=pX -h localhost gxdb_ncrl < /tmp/settings.sql

update pac_settings set bquota_m=0 where id="global";
update pac_settings set bquota_w=0 where id="global";
update pac_settings set bquota_d=0 where id="global";
update pac_settings set bquota_s=0 where id="global";
update pac_settings set bonus_interval=5 where id="global";






#######################################################

~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                                                                                                                                                     
~                            
