By Andre on Thursday, 29 September 2016
Posted in Technical Issues
Replies 3
Likes 0
Views 566
Votes 0
Hi team,

I'm trying to optimize my database and before I started I used Akeeba Backup component. At the end of the backup there was a warning Column params of table #__easyblog_mediamanager contains 3274262 bytes of data. This may cause restoration issues. that makes me very uneasy....

Can/should this table be emptied, can/should the rows be dropped? What is the warning all about and what can be done to optimize this "greedy" table?

Thanks,
Andre
hey there,

Currently i am not really sure why you hitting this warning when you trying to restore, perhaps you can backup this table #__easyblog_mediamanager and store in other place first, then remove all the existing row data from that table.

After restore finish then import back that data in that table.
·
Thursday, 29 September 2016 17:09
·
0 Likes
·
0 Votes
·
0 Comments
·
I'm not needing to restore it now but before any major changes on the site I use Akeeba Backup in case I need to restore the site to an earlier state. It usually takes me about 30 seconds to do that as everything is stored insinda a single .JPA file.

My qyestion is related to the EasyBlog table #__easyblog_mediamanager; what is it for, what does it do, why it;s so big and can I empty it as a database optimization step?
·
Thursday, 29 September 2016 17:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Basically what this table does is recorded the new folder and file which you created/uploaded from the Easyblog media manager.

May i know your site is it using Easyblog older version before? because I believe those data was created from your older version of Easyblog. In Easyblog 5, we no longer use this table but to be safe the old data still need to be there.

Perhaps you can export this table #__easyblog_mediamanager for backup first, then truncate this table #__easyblog_mediamanager and do your database optimization step.

After you done, try take a look the existing post and see is it everything work fine.
·
Thursday, 29 September 2016 17:51
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post