mysqldump without lock
/usr/bin/mysqldump –single-transaction –lock-tables=false mydb | gzip > /var/mydb.sql.gz
Read MoreInstall MySQL to Debian 12
MySQL server package installation: Install package: wget https://dev.mysql.com/get/mysql-apt-config_0.8.28-1_all.deb dpkg -i mysql-apt-config_0.8.28-1_all.deb *During the installation, you…
Read MoreHOW TO MONITOR MYSQL/MARIADB USING ZABBIX SERVER
Setup a MySql/MariaDB Monitoring User: root@web01:~# mysql -u root -p mysql> create user 'zabbix'@'localhost' IDENTIFIED…
Read More