From the ERAPS Blog area:
[ http://www.eraps.net/entry.php?1-What-a-project! ]
Blogs / The Architect / What a project!
"Moving the ASPD database from a very early version of MySQL database to the lastest version seemed a rather easy transition. It's one I have done before so when I was asked by Angelimnot to work with her on the data transition, I said sure thing! THEN, I looked at the backup of the ASPD data! In all, uncompressed it was over 12Gb with over 18million line entries. I made two attempts to import the file in one pass, no dice.
I spent the next 3 days splitting the database into what eventually turned out to be 142 different scripts to create the database, create and populate the data tables and change the permissions on the database and tables to allow the vBulletin software to connect, query and manipulate the data. It took over 44 hours for those scripts to complete execution. No errors were encountered!
Now, I have handed the task of making sure the forums are correct to Deuce and Angel. I'm back to making minor changes in the configs and setting up the new Flash Chat application. I can't wait to get back to my passion, hobbying! I need some playtime."
Yes - Call it a reincarnation of ASPD.