the move is underway

[keithj]

shutupandprog.com has been moved from server-06 to server-08. i'm now waiting for them to set up my new database and then i can begin the restore.

oh, and also, all the leaves which have provided weeks of crazy-ass colours are all blowing off the trees today. that kinda makes me sad. i hate the time between when the leaves fall and first snowfall.

Comments

[keithj]

they just got the database up. it's gonna take me a couple hours to rebuild it.

[keithj]

it's actually going pretty fast. i'm up to 9 of 17 files restored.... but i kinda cheated and dumped the search words table which lessened the number of rows by 250,000..... but it's gonna take hours of unmanned script running to rebuild that before the forum search feature will work again.

i tested all of this on my local server lastnight so i knew exactly what needed to be done to make it go as quickly as possible. but the script to rebuild the search tables is really slow. it has to go through each post in the forums and extract each word.... it does this 100 posts at a time... i left it for an hour and it was up to 1100 posts.... so it'll probably take about 15 hours