[Clipart] [support.osuosl.org #5204] [openclipart] Database maintenance

[Jon Phillips]

Thanks Rudy! Cheers to you! cc'ing ocal list for all to keep eyes
peeled.

Jon

On Tue, 2008-09-09 at 22:35 +0000, Rudy Grigar via RT wrote:
> > > Are these files controlled by any sort of revision control?  If not,
> > I
> > > can go ahead and switch this over for you today.
> > > '/var/www/openclipart.org/htdocs/wiki/LocalSettings.php' looks to be
> > the
> > > only file still using db1.osuosl.org (for the mediawiki wiki).
> > 
> > Ok, that is fine...the other one is
> > '/var/www/openclipart.org/htdocs/cc-config-db.php'
> > 
> > That is high traffic and the main place of action for
> > http://openclipart.org fyi so make sure if switching, the dbs are
> > synced...maybe have to turn the site off to for about 5-10 minutes if
> > you think best to make sure we have lowest sync problems...let me
> > know!
> > 
> > > The '/var/www/openclipart.org/conf/openclipart.org.conf' file I am
> > not
> > > sure about.  Is this file just used for backups?  If so, I can go
> > ahead
> > > and switch it over to the proper database.
> > 
> > This is for doing backups, and such.
> > 
> > > If it's okay with you, I will go ahead and switch these over.
> > 
> > Ok, but make sure the databases are synced!
> > 
> > > If you need to be around, we should push this to next week (I will
> > be
> > > out of town the rest of the week).  Monday at 3PM PST would work.
> > 
> > Ok, just let me know what you advise.
> > 
> > Cheers!
> > 
> > Jon
> > 
> 
> I went ahead and switched the wiki over to the new location and
> everything looks to be happy.  The changes can be seen in
> '/var/www/openclipart.org/htdocs/wiki/LocalSettings.php'
> 
> '/var/www/openclipart.org/htdocs/cc-config-db.php' had already been
> migrated over to the new database earlier this year.  It was already
> pointed at ocl.db.osuosl.org.
> 
> For whatever reason, the backup and wiki configs were left pointing to
> the old database on db1.
> 
> Everything has now been moved to the new database, please let me know if
> you experience any issues related to this, i took a quick visit around
> the wiki and main site and everything looked to be working.
> 
> Thanks!
> 
> --
> Rudy Grigar
> OSUOSL
> 
-- 
Jon Phillips
San Francisco, CA + Guangzhou + Beijing
GLOBAL +1.415.830.3884
CHINA +86.1.360.282.8624
jon at rejon.org
http://www.rejon.org
IM/skype: kidproto
Jabber: rejon at gristle.org
IRC: rejon at irc.freenode.net