boduke

I deactivated and deleted both instagram plugins. I also installed the optimizer and set it to delete transients and run weekly. Hopefully I got everything under control. Thank you so much to everyone who helped here. I could not have made any progress without this board.

So Hostgator was able to remove all the transient files and get the site back up and running. I am able to log it and it looks like things are good. I’m looking into installing https://www.ads-software.com/plugins/wp-optimize/ to automatically delete the transient files as Steven suggested and I will be correcting the spelling of memorabilia. Is there a way to see which plugin is causing the file size issue? This is the latest message I got from hostgator customer support:

I have completed importing the repaired wp_options table into your database with the excluded "transient_data" entries and verified your site is loading as well as the admin page. 

After viewing your site It appears a plugin is creating these large _transient_feed_ which is referencing all 446 posts in each of them. 
I suspect it is related to one of your fee plugins listed below which you may either want to disable/delete or ensure settings are properly configured. 
#9   [  Active] RSS Feed Widget                  Version 2.9.1        (File: rss-feed-widget/index.php)
#10  [  Active] Smash Balloon Instagram Feed     Version 6.1          (File: instagram-feed/instagram-feed.php)
#14  [  Active] WPZOOM Instagram Widget & Block  Version 2.0.12       (File: instagram-widget-by-wpzoom/instagram-widget-by-wpzoom.php)

Since importing your wp-options table back into your database, the table has already grown to 55MB while I was browsing the site, this is exclusively due to _transient_feed_  entries. 

Since we did not have sufficient space to backup your original wp-options table, I have it temporarily saved on the server where myql is unable to read it, but in the event we need to revert the changes I made to the table we could perform this entire process again. To allow you time to review your site, I am setting this case to reopen in 7 days in order to remove the 330GB backup of your original wp-options table from the server.

This sounds like a good option, but I have no idea what it means.

I don’t. I’m more or less learning as I go. But I think it’s my only option.

Samuel Wood, your response seems to be the easiest solution. Thank you. I sent your message and this is the response I got. Should I have them delete without a backup?

Thank you for contacting Hostgator support.

I apologize for any problems you experienced which led to you to contact live support, however I will be happy to assist you. Please note that due to the size of the database “327 GB” we would not be able to make a backup of it prior to performing the requested action of permanently removing all rows containing “transient” data from the database wadjaq0a_WzUdgwiMX3lOOSSG. Once we remove the data it would not be recoverable, please confirm if you still want us to proceed with this request with the knowledge that we will not be able to make a backup of the database.

If you have any questions or concerns, please don’t hesitate to contact support via online chat or calling 1-866-96-GATOR or 713-574-5287. We are more than happy to assist you at anytime. Our associates are available 24 hours a day 7 days a week.

I don’t know how to do anything because I can’t get past that update page. All I can do is log in and then I’m stuck on the error page.

It’s sort of a tough word to spell. So installing that plugin sounds like it’ll be a good idea. But, right now I can’t get to the dashboard. When I go to https://dukescollector.com/wp-admin/ it gives me the Database Update Required and when I press the update button it takes a while then gives me the ‘Sorry, that didn’t work.
Please try again or come back later.
503 Error. Service Unavailable.’
found at this address:
https://dukescollector.com/wp-admin/upgrade.php?step=1&backto=%2Fwp-admin%2F
What are my options?

• This reply was modified 2 years ago by boduke.