I used Rebuild Search Index
on my phpBB 2.0.6 board. The installation couldnt be easier, just copy the two files to the proper directories and it shows up in the Admin Panel of your forum.
I did replace the default 100 with 25 in the admin_rebuild_search.php to slow it down a little. My new host has implemented the max questions limit so I only have 36,000(x 3 users or 108,000) per hour. Just click the rebuild index button in the Admin Panel and let it run over night.
Just for example. My database on the day I moved it was 45+ MB with over 20 MB being the two tables used for searching taking out these two tables reduced my file size by nearly half but more importantly when restoring where this max questions limit is in place was the number of lines (questions) in the mysqldump file was reduced from 1,350,000 to a paltry 250,000 lines which I was able to send to my new database (108,000 per hour max) using another script bigdump.php
which you can tweak around the values to throttle it down. Just shut your forum down for the night and let it go
One of the many benefits of bigdump.php is that it will restore from a file you have on your server instead of coming from your local machine. You can upload a gzip file (in my case for a 45 MB database the dump was 98 MB and gzipped it was 13 MB) and use a utility like myshell.php
to gunzip it on the server with the following syntax.
gunzip -d filename.gz
(NOTE: I put myshell.php and bigdum.php in my phpMyAdmin directory where they are password protected. Might not want to leave these laying around your site)
Once your forum is back on your server the Rebuild Index mod takes care of the huge wordmatch table (I ran this the following night without closing the forum).
I sure would like to see some of this built into future versions of phpBB (particularily the ability to save the database backup on the server and the the ability to throttle the restore, I think this latter will become more of an issue in the future because it is my understanding the max questions is a new feature in mysql that allows the host to set this value to disable your board if you exceed it) as it was a real pain to find and figure out these tools plus as disparate pieces I will have to remember it all next time I need to do this.
Hope this helps some of you on slow connections when dealing with these enormous (in terms of uploading and downloading) backup files.