Question List of MySQL queries for installation

[janklerks]

Ok, so our forum has a big post table (61 million posts) and there's no way I can run the install script without things breaking horribly.

Any chance I can get instructions on what queries to run manually? I'm paging through the stuff in the install directory, but I'm not sure if I'll see it all, All I really need are the queries for the post table, i assume, as it seems the install script only tries to create new columns if they dont' already exist.


Thanks

 

[Fillip H.]

The instructions in this post: http://www.dragonbyte-tech.com/f52/product-import-failure-big-board-questions-9176/#post51646 should help you

 

[janklerks]

serves me right for not searching enough. Thanks!

 

[Fillip H.]

I didn't mean to come off as telling you you should have searched - it's just easier for me to post a link rather than a full new post. Sorry

I'll create a sticky thread in each of the support forums with these instructions

 

[janklerks]

Looks like you're missing one, at least, my installation got hung up on:


ADD dbtech_thanks_cache MEDIUMTEXT



(I'm using percona's pt-online-schema-change to add these tables, so it takes a few hours each time)

 

[Fillip H.]

Updated the sticky threads, thanks