Post by zaidladha » Tue Jul 24, 2018 1:38 am

Hi,
Can anyone please help explain this? I have a table in my Opencart database called oc_bots_report

I have been trying to backup the database but it maxes out before it finishes because of how huge this table is. I am exporting the database without this table so I at least have a backup of everything else.

Do I need to keep this table? any ideas why it's there?

The columns are:
Link
Bot
IP
Date

examples:

https://www.MYDOMAIN (changed for sample)
Mozilla/5.0 (iPhone; CPU iPhone OS 7_0 like Mac OS...
207.46.13.157
2018-07-23 11:18:57

https://www.MYDOMAIN (changed for sample)
Mozilla/5.0 (compatible; bingbot/2.0; +http://www....
40.77.167.193
2018-07-23 11:18:57

https://www.MYDOMAIN (changed for sample)
Mozilla/5.0 (compatible; BLEXBot/1.0; +http://webm...
46.4.105.24
2018-07-23 11:18:57

Active Member

Posts

Joined
Wed Jun 05, 2013 3:07 pm

Post by straightlight » Tue Jul 24, 2018 1:47 am

This table originates from an installed extension. All extensions are running individually between each OC versions. If you need to make a backup of your database, you should normally be able to do so. However, you should contact the extension developer from where you originally downloaded this extension knowing the alternatives about this database table in particular.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by zaidladha » Tue Jul 24, 2018 2:00 am

Hi,
Thanks I will take a look and install each extension on a fresh copy. I checked my backups and it does seem to show up at a certain point, just don't think I had any extensions installed around then. Surprised that it wouldn't auto flush or something as its bigger than my entire database. I wonder if anything is querying it and its slowing down my site.

Active Member

Posts

Joined
Wed Jun 05, 2013 3:07 pm
Who is online

Users browsing this forum: No registered users and 52 guests