Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems?

2015-02-12 Thread Christian Hammond
@googlegroups.com Date: February 12, 2015 at 9:25:04 AM To: David Trowbridge trowb...@gmail.com Cc: reviewboard@googlegroups.com reviewboard@googlegroups.com Subject:  Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems? Hi David, Christian, Thanks

Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems?

2015-02-12 Thread Eric Johnson
reviewboard@googlegroups.com Subject: Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems? Hi David, Christian, Thanks for your help so far! Yesterday, I was able to find the time between meetings to try the conversion approach that Christian

Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems?

2015-02-12 Thread Eric Johnson
Hi David, Christian, Thanks for your help so far! Yesterday, I was able to find the time between meetings to try the conversion approach that Christian suggested, and it appeared to work. I have to test it again today, to make sure I didn't somehow trick myself. As for jumping to the later

Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems?

2015-02-11 Thread David Trowbridge
One more question-- is there a reason why you're going 1.7.7.1 - 1.7.8, instead of just jumping straight to the latest 1.7.x (or even latest 2.0.x)? There have been a great many bugs fixed since 1.7.8, including, I believe, some about key lengths with mysql utf-8 indexes. -David On Wed Feb 11

Re: Crazy difficulties trying to upgrade from 1.7.7.1 - any tool for finding/correcting DB problems?

2015-02-11 Thread Christian Hammond
Hi Eric, It sounds like a lot of the problems boil down to the MyISAM vs. InnoDB incompatibility. I recommend altering the tables using the MySQL command line and not a dump/load. You should be able to do this by performing the following on each table:     ALTER TABLE `tablename`