Pligg Mysql And Errors
Hi, my site was working perfectly when i decided to buy a new pligg template with new modules, then my hosting sent me an email saying:
“The script you ran to clear a cache table in your database has caused a massive overload on the server initiating huge number of MySQL queries:
| 7545598 | choowawa_new | localhost | choowawa_new | 600 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545660 | choowawa_new | localhost | choowawa_new | 596 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545681 | choowawa_new | localhost | choowawa_new | 594 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545730 | choowawa_new | localhost | choowawa_new | 591 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545739 | choowawa_new | localhost | choowawa_new | 590 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545774 | choowawa_new | localhost | choowawa_new | 587 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545777 | choowawa_new | localhost | choowawa_new 587 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545784 | choowawa_new | localhost | choowawa_new | 585 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
These are part of the queries.
You should contact an expert local web developer before you execute the same action. The load caused from your account was over 120 and on 4 QUAD core CPUs and 12GB or ram machine this means that there should be a malfunctioned script on your website. Please request from your developer to download your website scripts and create dump of your database and to optimize it.”
Now with this, I decided to just ask my hosting to reupload my old files, which meant losing some (not all) of the current database, members etc…
What I want the programmer/developer to accomplish is to bring back the lost member registrations and news using the most current backup file that i have. Is this possible?