Archive for Листопад, 2017
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
#mysql_upgrade -u [username] -p
#mysqlcheck -u [username] -p --all-databases --check-upgrade --auto-repair
#systemctl restart mysqld
mysql> show events;
Empty set (0.00 sec)
Replase date format in file name
Mass replase date format in filename
Example:
From filename_012017.txt to filename_12017.txt
ls | sed -e 'h;s/_0/_/;x;G;s/^\(.*\)\n\(.*\)$/\ln -s \1 \2/' | sh