duanqiongdu9916 2014-04-12 13:59
浏览 89
已采纳

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

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    
  • 写回答

2条回答 默认 最新

  • doudou20145 2014-04-16 10:48
    关注

    [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`;

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 matlab调用stl文件时报错说内存不足
  • ¥20 医学图像格式、医学图像后处理
  • ¥15 MATLAB中的矩阵分离问题
  • ¥15 服务端可运行语言,解析unity文件
  • ¥15 英飞凌TC387使用MCAL唤醒TJA1145问题
  • ¥15 android tv图标显示异常
  • ¥20 (标签-AR|关键词-预测分析)
  • ¥15 QT IFW 自定义界面添加lineedit小键盘输入数字无效果
  • ¥15 python thinter动态建立Entry并读取数据
  • ¥150 电路仿真,演示反激变压器升压