Monthly Archives: Листопад 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