Category Archives: MySql

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