Softaculous crash and Duplicate mysql tables

Softaculous crash and Duplicate mysql tables, Does softaculous generate duplicate mysql tables in a database and what to do after a crash and installation records gone (1 Replies, Read 1167 times)

steverino	# September 2, 2020, 1:37 pm
Group: Member Post Group: Newbie Posts: 2 Status:	I have been wondering why my Wordpress mysql databases for small sites are so large (+2GB). I took one site to play with some optimizing plugins to try and shrink the DB and I cloned the site. The original site was 2.17GB, the cloned site through Softaculous was 87MB. Within two hours the cloned site was 1.8GB. I looked at the mysql database with phpMyAdmin and instead of the typical 30 or so tables for the site, there were hundreds. The original Wordpress tables all had a 6 letter prefix and they repeat again and again with each repeated set of tables preceded by a different 6 letter prefix. I went to create a staging site of another site with a large DB and during the process I hit a disk memory wall. Softaculous froze (2 hours at 95%) and I closed the Softaculous window and went to FTP and cleared things off the disk. When things were working again, where there should have been 6 installations showing in Softaculous there were none. They all disappeared. Something is still happening behind the scenes however as Softaculous is running the updates for those sites. 2 Questions: Does using Softaculous grow a database file size through creation of duplicate database tables of a site during staging and cloning routines? Is it possible to restore Softaculous with the installations that were there before the memory crash?
IP: --

Users viewing this topic
	1 guests, 0 users.