How to Disable the Cache via the Database in Magento

cachedatabasedebuggingdevelopment

I have an automated job which converts our production database backups into development-friendly databases. I'd like to include the disabling of Magento's cache in this job as well, but haven't found where it would be configured.

I've looked in core_config_data but didn't see any relevant records. What tables and records would I need to update to be equivalent to System > Cache Management > Select All [check-boxes] > Actions = Disable > Submit?

Best Answer

All of the cache information is stored inside a table named core_cache_option.

If you browse to this table you will see that it contains a code and a value; the code being the type of cache and the value being a 0 or 1 representing off or on. Simply change the values based upon your needs.

Related Solutions

Magento 1 – How to Disable Cache for Particular Section or Block

You can try

    <reference name="needed block">
        <action method="setCacheLifetime"><s>null</s></action>
    </reference>

    <reference name="needed block">
        <action method="setCacheLifetime" />
    </reference>

to set it to null.

But probably it is better to use ajax.

There is a good article about null or 0 meaning ~~http://blog.kyp.fr/make-a-clean-sweep-of-commons-magento-cache_lifetime-workarounds-usage-in-cache-block-policy/~~ ^{(link is broken)}

How to Enable Magento 1.9.x Cache to Store in Database

edit the app/etc/local.xml and add this inside the <global> tag (position not important)

<cache>
    <backend>database</backend>
</cache>

Best Answer

Related Solutions

Magento 1 – How to Disable Cache for Particular Section or Block

How to Enable Magento 1.9.x Cache to Store in Database

Related Topic