MySQL Upgrade - Issues with Size

[schipper]

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:

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);

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.

[paulbaker]

If you go to (in 1.11.4 at least) Extensions -> Search you will see a Statistics tab which shows you a page of the most popular words searched for. You can also download a full CSV showing them all. I believe the SQL data you pasted stores this info and so if you're happy losing that then you can remove these lines from your SQL file.

Of course, make a backup first.

[schipper]

Thank you! Clearing out the stored search words in the Extensions worked. My file size went down to 1.5MB!