I just upgraded from 2.0.7 to 2.0.12. Everything seems to be working fine. In fact, I’ve had a customer or two place a successful order since I reopened.
Database size before the upgrade was something like 140 MB.
Now it’s only 21 MB.
Did I lose a bunch of data or did it just get super optimized?
I had already deleted all my stats and logs… before then it was over 400 MB!!
Could be the cscart_stored_sessions table that was huge!! Mine was one quite huge at one point and caused problems with authentication for some reason. Then I empty the table and it was fine.
[quote name=‘ogia’]I just upgraded from 2.0.7 to 2.0.12. Everything seems to be working fine. In fact, I’ve had a customer or two place a successful order since I reopened.
Database size before the upgrade was something like 140 MB.
Now it’s only 21 MB.
Did I lose a bunch of data or did it just get super optimized?
I had already deleted all my stats and logs… before then it was over 400 MB!![/QUOTE]
Glad to hear you made it to 2.0.12 Ogia!
A good deal of the extra db size was probably related to the sessions table. They have also made several optimization changes along the way up to 2.0.12.
PS: What all did you end up having to do to get to 2.0.12 ?
I guess I’ll have to watch the sessions table. :eek:
I ended up using the built-in upgrade. I just had tooo much data to work with on my computer. I also tried using localhost and the data was getting truncated and/or processes were timing out. CS-Cart staff replied to my support ticket that they’d “upgraded” my test store, but I couldn’t even log into the admin panel due to all the database errors. I suspect the database was truncated in that case too.
I finally determined why I couldn’t upgrade on my server… my installation directory had been renamed :oops: Duh. Once I fixed that and got my database optimized it was smooth sailing.