On Tue, Jul 20, 2010 at 12:19 PM, Pierre Schmitz <[email protected]> wrote: > On Tue, 20 Jul 2010 12:00:19 -0500, Dan McGee <[email protected]> > wrote: >> On Tue, Jul 20, 2010 at 11:51 AM, Pierre Schmitz <[email protected]> wrote: >>> On Tue, 20 Jul 2010 10:59:35 -0500, Dan McGee <[email protected]> >>>> We also do not have enough room to dump and reload a second copy of >>>> the DB. Any ideas on this, anyone? We didn't think very straight when >>>> we were sizing /var on a DB machine... >>> >>> Good catch. But it should just fit. There is 3.2GB free disc space and >>> the bbs database takes 1.2GB. Once everything is running the phpbb >>> database can be removed. (I can keep a local dump file in my home dir >>> for some time though...just in case) >> >> No, that is not how InnoDB works which we recently switched to for >> these tables. Once the data file grows we do not get the space back, >> period, unless we do a complete dump and load of every database. Log >> space needs to be accounted for, which makes our weekly swing of used >> space vary by 27%: >> https://stats.archlinux.org/munin/archlinux.org/gudrun/df.html > > Ah innodb ok. That saves all dbs in one file. (I was using myisam here) > Hmm, we might run into a problem with our var partition some day...soon. > > Well, let's change the plan to this: > * make a backup of the db > * rename phpbb to fluxbb (a rename should be painless, right) > * .. > * run the update script on the live db > > For the time frame: I got time now till late tonight (let's say now + > 5h) or tomorrow. For Thursday I probably don't have enough time if > anything goes wrong. Otherwise some day next week.
I probably can't do it tomorrow unless it is way late my time as that is when I fly to Toronto. I also am booked out the rest of today through 5 hours from now so that is out too. :/ Thursday might work if we do it afternoon over here/evening for you, but you say you might not have a ton of time. If things do go wrong I will probably be around enough people that can help out at least. Maybe we can shoot for some day next week. -Dan
