Database Huge

[suekay]

I've noticed that my database size keeps increasing by about 7MB a week. I'm not adding any new products, are there some house keeping duties that I should be doing to clear out the database?

Thanks
Suekay

[Steven300]

Try going to Admin -> Tools -> Store Manager and empty the Admin Activity Log table.

Does that make any difference?

[bunyip]

Also check that you're not archiving emails - that will add a huge amount of data each week on a busy site. Admin > Configuration > Email Options.

[suekay]

Try going to Admin -> Tools -> Store Manager and empty the Admin Activity Log table.

Does that make any difference?

Tried it - doesn't seem to have made a difference but it may take awhile for the Mb to update

Thanks
Suekay

[suekay]

Also check that you're not archiving emails - that will add a huge amount of data each week on a busy site. Admin > Configuration > Email Options.

It was true so i have reset to false. How do I get rid of the files in the archive to reduce the file size?

Thank you
Suekay

[suekay]

Also check that you're not archiving emails - that will add a huge amount of data each week on a busy site. Admin > Configuration > Email Options.

That fixed it, I found the table to delete from and there were 30K of emails!!!

Than k you
Suekay

[DrByte]

You can utilize the Email Archive Manager addon to view the email archive contents and periodically purge the contents if needed.

[inovermyhead]

That fixed it, I found the table to delete from and there were 30K of emails!!!

Than k you
Suekay

For my information, can you just empty the email archive table using phpMyAdmin? I have the same situation, and tried using Email Archive Manager, but that didn't seem to work. Installed it on our localhost to test, there's no errors, but it just displays a blank admin screen.

Thanks for any help.

[DrByte]

... but it just displays a blank admin screen.

Best to figure out what's causing that blank screen. Use the debug utility mentioned in this FAQ article to find the cause: https://www.zen-cart.com/tutorials/index.php?article=82

It's probably related to a damaged file, which will likely be mentioned in the logs that get generated when you trigger that blank page again. You'll likely need to refer to this FAQ article after that: https://www.zen-cart.com/tutorials/index.php?article=87

[inovermyhead]

Well, Dr. Byte, this seems easy enough, but I copied enable_error_logging.php to the extra_configures folder in admin. Then made sure the permissions for the cache folder would allow full control. Then I tried the Email Archive Manager. Then I checked the cache folder, but there wasn't anything new in it.

Suggestions?

B.