Magento disable cache from database

Question

There is a way to disable cache from System->Cache Management menu.

How can I do the same without entering to site, using Database SQL query?

Answer 1

The easiest way to disable cache is by using SQL query:

UPDATE `core_cache_option` SET value=0;

And clear your cache folder just to be sure:

rm -rf <YOUR SITE PATH HERE>/magento/var/cache/*

In Magento Enterprise Edition you also have to clear the full_page_cache directory (thanks to Bartosz Górski):

rm -rf [YOUR SITE PATH HERE]/magento/var/full_page_cache/*