MySQL Upgrade - Issues with Size
Posted: Mon Mar 25, 2013 8:56 pm
My host (1and1.com) has asked that i upgrade my MySQL 4 to MySQL 5.
The issue i am having with this one is that the SQL file (not zipped) is large -- 57.2 MB and the host has an upload limit of 49 MB.
I've tried "zipping" it with gZip and it does not work - just shoots back nothing. I think this is because at the top of my query - it says to "create database" when it doesnt need to (im putting it into a new database already)
So - i took a look at the code and was wondering why in the heck would it be so large? Its NOT a large site! (And note that i've successfully upgraded SQL for another client with the same host.)
I saw 905,000 lines of code similar to this:
Is that really necessary? Whats that doing in there? Seems like maybe its caching something from the input of the SEARCH box on the website? Is that possible?
(I did clear the cache before i downloaded the SQL)
Any tips, advice would be appreciated... otherwise site will go bye-bye.
OTHER INFO:
- Just upgraded from CMSMS 1.4.1 to 1.11.
- Site is located here: http://www.stayinthepink.com/
Thanks in advance.
The issue i am having with this one is that the SQL file (not zipped) is large -- 57.2 MB and the host has an upload limit of 49 MB.
I've tried "zipping" it with gZip and it does not work - just shoots back nothing. I think this is because at the top of my query - it says to "create database" when it doesnt need to (im putting it into a new database already)
So - i took a look at the code and was wondering why in the heck would it be so large? Its NOT a large site! (And note that i've successfully upgraded SQL for another client with the same host.)
I saw 905,000 lines of code similar to this:
Code: Select all
INSERT INTO `cms_module_search_words` VALUES ('ihnrcfu', 1);
INSERT INTO `cms_module_search_words` VALUES ('zmgwvxr', 1);
INSERT INTO `cms_module_search_words` VALUES ('ravbwch', 1);
INSERT INTO `cms_module_search_words` VALUES ('vxxozig', 1);
INSERT INTO `cms_module_search_words` VALUES ('gnyhzix', 1);
INSERT INTO `cms_module_search_words` VALUES ('biitirh', 1);
INSERT INTO `cms_module_search_words` VALUES ('fplswei', 1);
INSERT INTO `cms_module_search_words` VALUES ('epvutam', 1);(I did clear the cache before i downloaded the SQL)
Any tips, advice would be appreciated... otherwise site will go bye-bye.
OTHER INFO:
- Just upgraded from CMSMS 1.4.1 to 1.11.
- Site is located here: http://www.stayinthepink.com/
Thanks in advance.
