Clean my database
By Chaon on Thursday, 07 February 2019
Posted in General Issues
Likes 0
Views 701
Votes 0
Hello again.
I recently noticed that my easyblog database is way to big in size and mostly the size is used by the tables
#_easyblog_revisions
#_easyblog_trackback
#_easyblog_trackback_sent

Is there an easy way to clear those tables without causing problem to EB? specially for trackback i noticed that the backlink section is not available any longer in EB as it was during past versions, so that's pure trash. How can i get rid of it?
Thank you
Hi Chaon,

You can safely Drop these two table, #_easyblog_trackback and #_easyblog_trackback_sent as these table were no longer used in latest version of EasyBlog.

For #_easyblog_revisions table, you can truncate all the data inside the table but you will lose all of the revisions history for each posts created on the site, https://take.ms/Z9dAZ . If you do not mind about having these feature, you can safely perform the truncation of this table. You can also reduce the number of revisions stored in database by setting up the revisions limit in your backend > EasyBlog > Settings > Editor > Maximum Revisions To Keep, https://take.ms/Srhp7 .

As a precaution step, please perform a backup of your database before you initiate the process.

Hope these help.
Ezrul Fazwan
·
Thursday, 07 February 2019 11:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you very much.
After cleaning those tables + the joomla smart search table i managed to make my db 200mb and before it was 1,5gb.
Chaon
·
Friday, 08 February 2019 06:10
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Chaon.
Ezrul Fazwan
·
Friday, 08 February 2019 11:16
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post