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
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
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.
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.
Who is online
Users browsing this forum: No registered users and 52 guests