Is it possible to exclude a column in a table? I take my dev site and copy it over top of my production site every night. I want to keep the page hits counter on the prod site so i get useful stats from it. It's a column called hits in the _content table. It is possible to just exclude that one column when i do my backups?
#29469 Exclude Joomla Hits
Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Environment Information
Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a
Latest post by dave.hook on Wednesday, 04 April 2018 09:51 CDT
Tuesday, 03 April 2018 15:17 CDT
dave.hook
Wednesday, 04 April 2018 02:51 CDT
tampe125
Akeeba Staff
Hello,
I'm sorry but that's not possible to exclude a single column from the backup, it could result in a completely corrupted database.
Regarding your specific issue about page hits, please remember that Joomla is not the correct tool to track them down. Joomla will simply update the counter every time the page is loaded, regardless from the user triggering it (a publisher just checking the changes, a search engine spider or a bot surfing the web).
The best tool is to use a website analytics tool such as Google Analytics: in that way you can really track down which are the most visited pages, reducing the risk to have wrong values.
I'm sorry but that's not possible to exclude a single column from the backup, it could result in a completely corrupted database.
Regarding your specific issue about page hits, please remember that Joomla is not the correct tool to track them down. Joomla will simply update the counter every time the page is loaded, regardless from the user triggering it (a publisher just checking the changes, a search engine spider or a bot surfing the web).
The best tool is to use a website analytics tool such as Google Analytics: in that way you can really track down which are the most visited pages, reducing the risk to have wrong values.
Davide Tampellini
Developer and Support Staff
🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Wednesday, 04 April 2018 09:51 CDT
dave.hook
thanks - You can close this request.