If you receive an error message like
Error Table 'table.wp_wc_follow_users' doesn't exist, you may have inadvertently caused the problem by updating two plugins at the same time. I was updating the wp support and wp disquz tables, received an error, and afterwards started seeing this error.
To fix it, use the sql query below. When doing so, make sure you execute it on the correct database.
Continue reading WordPress Error Table ‘alertadigital.wp_wc_follow_users’ doesn’t exist
I recently had a database that was growing at an alarming rate. I needed to determine which table was consuming the space to see if I could do some pruning.
During my research I was able tl locate the following command which worked wonderfully for my purposes.
Note: for this command to work you need a MySQL instance of at least version 5.0.
Continue reading MySQL database too Large
Administrators of InnoDB databases will recognize that InnoDB tables grow in size...but never shrink.
Whether this is a bug or a feature has been heavily discussed in years past, check here or here for more information, but either way the problem is that an InnoDB will grow the ibdata file, but not shrink it.
Continue reading Shrinking a MySQL Database