mysql-tools - aha00a

DDL and CRON script generator

Data

database id pw

-- DDL CREATE DATABASE __database__ CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; CREATE USER '__id__'@'localhost' IDENTIFIED BY '__pw__'; CREATE USER '__id__'@'%' IDENTIFIED BY '__pw__'; GRANT ALL PRIVILEGES ON __database__.* TO __id__@localhost WITH GRANT OPTION; GRANT ALL PRIVILEGES ON __database__.* TO __id__@'%' WITH GRANT OPTION; FLUSH PRIVILEGES; # cron 0 5 * * * mysqldump --default-character-set=utf8mb4 --no-tablespaces -u __id__ -p__pw__ __database__ | gzip > ~/backup/mysql/__database__.`date +\%Y\%m\%d.\%H\%M\%S.sql.gz` // url jdbc:mysql://__id__:__pw__@localhost:3306/__database__?characterEncoding=UTF-8&allowMultiQueries=true& #!/bin/sh (crontab -l ; echo "0 5 * * * mysqldump --default-character-set=utf8mb4 --no-tablespaces -u __id__ -p__pw__ __database__ | gzip > ~/backup/mysql/__database__.`date +\%Y\%m\%d.\%H\%M\%S.sql.gz`") | crontab - echo " CREATE DATABASE __database__ CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; GRANT ALL PRIVILEGES ON __database__.* TO __id__@localhost IDENTIFIED BY '__pw__' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON __database__.* TO __id__@'%' IDENTIFIED BY '__pw__' WITH GRANT OPTION; FLUSH PRIVILEGES; " | mysql -u root -p -- DDL CREATE DATABASE __database__ CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; GRANT ALL PRIVILEGES ON __database__.* TO __id__@localhost IDENTIFIED BY '__pw__' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON __database__.* TO __id__@'%' IDENTIFIED BY '__pw__' WITH GRANT OPTION; FLUSH PRIVILEGES; # cron 0 5 * * * mysqldump --default-character-set=utf8mb4 --no-tablespaces -u __id__ -p__pw__ __database__ | gzip > ~/backup/mysql/__database__.`date +\%Y\%m\%d.\%H\%M\%S.sql.gz` // url jdbc:mysql://__id__:__pw__@localhost:3306/__database__?characterEncoding=UTF-8&allowMultiQueries=true& #!/bin/sh (crontab -l ; echo "0 5 * * * mysqldump --default-character-set=utf8mb4 --no-tablespaces -u __id__ -p__pw__ __database__ | gzip > ~/backup/mysql/__database__.`date +\%Y\%m\%d.\%H\%M\%S.sql.gz`") | crontab - echo " CREATE DATABASE __database__ CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; GRANT ALL PRIVILEGES ON __database__.* TO __id__@localhost IDENTIFIED BY '__pw__' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON __database__.* TO __id__@'%' IDENTIFIED BY '__pw__' WITH GRANT OPTION; FLUSH PRIVILEGES; " | mysql -u root -p

Result

Url

MySQL 8.x

MySQL 5.x