Category Archives: MySql

dump gzip only rowdata to another server

#!/bin/bash # loop isi file well_list.txt # kemudian dump | gzip ke server lain # contoh nama table xx_telo_xx while read p; do mysqldump -uuser -ppassowrd –skip-add-drop-table –skip-add-locks –lock-tables=false namadatabase $(mysql -uuser -ppassowrd -D namadatabase -Bse “SHOW TABLES LIKE ‘%$p\_%’”) | gzip -c | ssh user@servertujuan “cat > /home/user/backupdb-rowdata/only-rowdata_$p.sql.gz” done < well_list.txt

mysql 5.7 iqnore zero timestamp

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

mysqldump multiple table

mysqldump -uroot -ppasswd –skip-triggers –skip-add-drop-table –skip-add-locks dbcoba $(mysql -uroot -ppasswd -D dbcoba -Bse “SHOW TABLES LIKE ‘%coba%'”) > coba-backup-beberapa-table.sql tar -czf coba-backup-beberapa-table.sql.tar.gz coba-backup-beberapa-table.sql