[bitbender]

Hello All,

I just rebuilt my VB 3.0 from Beta 7,with VB 2.3.0 as input to verify the 'documented' attachments procedure I had used before(for my own sanity). I had not yet read the other methods beyond attachment_upgrade.php. I used a new data base, and a seperate directory structure for VB 3.0. The reason I do things this way is that the test and live Board are really two different virtual sites on on my rack, so they have differnt HTML structures. It also helps to make sure I don't stomp on my live board, because it uses a different DB names and users.

I'd like to know if the way I'm doing it is backwards, or ok. Seems to be working ok, but I have not yet tested using the file system store in VB3.0.

1. Copy live VB directories to a dummy set, ie vb23
2. Update vb23/admin/config.php to reflect new data base name bitbender_vb30
3. Backup "live" DB using mysqldump from SSH
4. Drop data base name bitbender_vb30 using MySqlAdmin from SSH
5. Create data base name bitbender_vb30 using MySqlAdmin
6. Grant Permissions to Db User using MySqlAdminfrom SSH
7. Restore to data base name bitbender_vb30 from backup using MYSQL from SSH
8. Used PhpMyAdmin and edited data base name bitbendertest_vb30 to;
   • ALTER TABLE attachment ADD filedata mediumtext NOT NULL
   • Change the settings field attachpath to point to correct directory structure /html/vb23/attach_archive
9. Ran REPAIR.PHP against the data base bitbendertest_vb30 from the vb23/admin folder
10. Copied attachment_upgrade.php to my vb23/admin folder
11. Edit the attachpath within the exec to ensure it is the same as attachpath above
12. Copied the attachment directory from live board to duplicate VB 2.3.0 structure /html/vb23/attach_archive
13. I had some server Issues - (you may NOT need to do this part);
    • Altered PHP.INI to allow for 360 seconds max execution
    • 16M total script consumption.
    • Adjusted my.cnf in /etc to allow a max_allowed_packet=4M
    This was required due to the size of some of the crap in my attachment folder. Because I had to make adjustments, I needed to restart some stuff.
    • Stopped apache
    • Stopped MySQL
    • Started MySQL
    • Started Apache
14. Ran /html/vb23/admin/attachment_upgrade.php This took about 15 mins for me (575Megs of attachments)
15. Uploaded VB 3.0 Beta 7.0 to VB30 folder
    • ===>vb30
    • ======>/admincp
    • ======>/ and so on
16. Altered vb30/includes/config.php for new DB user and data base name bitbender_vb30
17. Ran vb30/install/upgrade.php
18. Once all done and working, delete /vb23 directory

And it worked. If you would like to see, let me know, and I can issue a guest id to let you see. Now, since we can put a worm on a hook ten ways and a fish will still bite, who knows.. comments any one??