Skip to content

Spotweb reset database or clear local cache

Sweepr edited this page Oct 20, 2019 · 2 revisions

Reset your database

You will be able to reset the DB, using the command

php upgrade-db.php --reset-db , and confirm with yes.

This will reset the following table's: spots, spotsfull, spotsposted, spotstatelist, commentsfull, commentsposted, commentsxover, moderatedringbuffer, reportsposted, reportsxover, usenetstate, cache

Table's: users, usergroups, usersettings, sessions, settings, grouppermissions, security groups and filters are left intact.

Everything else get's truncated

Clear your local cache

To clear your local cache use the following command:

php upgrade-db.php --clear-cache This will truncate the cache table and empty cache folder on-disk. This could save a lot of data.

Or pass -yes to auto confirm, this will bypass manual confirmation so clearing cache can be scheduled using cron.

php upgrade-db.php --clear-cache -yes Bypass the manual confirmation so clearing cache can be scheduled using cron.