需要脚本文件来清除mysql数据库中的缓存

Question

I need to take dump of database, i do these things for dumping usually.

    login to phpmyadmin
    select database
    select sql tab
    paste these lines

        TRUNCATE watchdog;
        TRUNCATE cache; and
        TRUNCATE cache_admin_menu;

And click on OK to clean the cache.

This is the procedure i need to make it in .sh file so that i can run in Cron job    

Answer 1

[root@localhost home]# mysql -u root -ppasswd < /root/Downloads/testscript.sql

 

I had create one file with name testscript.sql

text in the file as follows

/*
 * My First MySQL Script - testscript.sql.
 * You need to run this script with an authorized user.
 */
USE dbname;                     -- Set system database 'dbname' as the current database
TRUNCATE `cache`;
TRUNCATE `cache_admin_menu`;
TRUNCATE `cache_block`;
TRUNCATE `cache_bootstrap`;
TRUNCATE `cache_field`;
TRUNCATE `cache_filter`;
TRUNCATE `cache_form`;
TRUNCATE `cache_image`;
TRUNCATE `cache_libraries`;
TRUNCATE `cache_menu`;
TRUNCATE `cache_page`;
TRUNCATE `cache_path`;
TRUNCATE `cache_rules`;
TRUNCATE `cache_token`;
TRUNCATE `cache_update`;
TRUNCATE `cache_views`;
TRUNCATE `watchdog`;