./bg_installer.sh {имя файла с архивом}!

general_log = 1
log_syslog = 0
general_log_file = /var/log/mysql/gen.log
log_builtin_as_identified_by_password = 1
log_error = /var/log/mysql/err.log
log_error_verbosity = 3
log_output = FILE
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_timestamps = SYSTEM
long_query_time = 3
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slo.log

contract_charge:  `lm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
contract_parameters_pref:  `lm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
contract_payment:  `lm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
contract_payment_deleted:  `lm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
contract_service:  `lm` date NOT NULL DEFAULT '0000-00-00',
contract_tariff:  `lm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
module_tariff_tree:  `lm` bigint(20) NOT NULL DEFAULT '0',
service:  `lm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
source:  `lm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
tariff_plan:  `lm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

mysqld --defaults-file=/etc/mysql/my.cnf --initialize-insecure --user=mysql --datadir=/var/lib/mysql

echo "ALTER USER 'root'@'localhost' IDENTIFIED BY '<пароль мускульного рута>';show warnings;" > /tmp/pre_bgb.sql
echo "CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY '<пароль мускульного рута>';show warnings;" >> /tmp/pre_bgb.sql
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;show warnings;" >> /tmp/pre_bgb.sql
echo "CREATE DATABASE bgbilling DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;show warnings;" >> /tmp/pre_bgb.sql
echo "CREATE USER 'bill'@'127.0.0.1' IDENTIFIED BY 'bgbilling';show warnings;" >> /tmp/pre_bgb.sql
echo "CREATE USER 'bill'@'localhost' IDENTIFIED BY 'bgbilling';show warnings;" >> /tmp/pre_bgb.sql
echo "CREATE USER 'bill'@'bgb' IDENTIFIED BY 'bgbilling';show warnings;" >> /tmp/pre_bgb.sql
echo "CREATE USER 'bill'@'%' IDENTIFIED BY 'bgbilling';show warnings;" >> /tmp/pre_bgb.sql
echo "GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'localhost';show warnings;" >> /tmp/pre_bgb.sql
echo "GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'%';show warnings;" >> /tmp/pre_bgb.sql
echo "GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'127.0.0.1';show warnings;" >> /tmp/pre_bgb.sql
echo "GRANT ALL PRIVILEGES ON bgbilling.* TO 'bill'@'bgb';show warnings;" >> /tmp/pre_bgb.sql

mysql -u root --skip-password -vvv --max_allowed_packet=100M --init-command="SET NAMES utf8" < /tmp/pre_bgb.sql

DROP DATABASE IF EXISTS bgbilling;
CREATE DATABASE bgbilling DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

sed -i -e "s/;/;show warnings;/" dump.sql

mysql -u root -p<пароль мускульного рута> -vvv --init-command="SET NAMES utf8" < dump.sql  > dump.log 2>&1