LuizFernando Posted August 10, 2018 Share Posted August 10, 2018 Galera, alguém tem algum script que limpe os logs do mysql? No caso toda a tabela log do mysql, um script que seja inserido pelo freebsd? Link to comment Share on other sites More sharing options...
[Admin] tierrilopes Posted August 10, 2018 Share Posted August 10, 2018 v_password="password" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.GameTimeLog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.bootlog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.change_empire;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.change_name;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.chat_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.command_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.cube;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.dragon_slay_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.fish_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.gametimelog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.goldlog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.hack_crc_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.hack_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.hackshield_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.invalid_server_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.levellog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.loginlog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.loginlog2;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.money_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.pcbang_loginlog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.quest_reward_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.refinelog;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.shout_log;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.speed_hack;" mysql -uroot -p$v_password mysql -e"TRUNCATE TABLE log.vcard_log;" Substituir "password" pela password do root de localhost. Se utilizas o gerador aqui colocado, essa password estará em backups/db/mp.txt Link to comment Share on other sites More sharing options...
LuizFernando Posted August 11, 2018 Author Share Posted August 11, 2018 Perfeito, muito obrigado tierri! Link to comment Share on other sites More sharing options...
Recommended Posts