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
Author Archives: ballacksave
disable service mysql and apache2
sudo systemctl disable mysql.service sudo systemctl disable apache2
ubuntu set datetime
timedatectl sudo timedatectl set-ntp no sudo timedatectl set-timezone Asia/Jakarta sudo timedatectl set-time ‘2020-07-04 23:59:00’
ubuntu change time zone
system@aggregator:~$ date Thu Dec 21 11:42:10 WIB 2017 system@aggregator:~$ sudo cp /etc/localtime /etc/localtime.old system@aggregator:~$ sudo ln -sf /usr/share/zoneinfo/Asia/Makassar /etc/localtime system@aggregator:~$ date Thu Dec 21 12:42:16 WITA 2017
test kirim email dari shell
echo “ballack test email” | mail -s “ballack test kirim email dari ep” admin@ballacksave.com
crontab
crontab -l current crontab to be displayed on standard output. crontab -e is used to edit the current crontab using the editor specified by the EDITOR environment variable.
restart network ubuntu 16
sudo ip addr flush eth0 sudo service networking restart klo rewel, pake cara klasik sudo ifdown eth0 && sudo ifup eth0
Disk Usage
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
Ubuntu set date manual
set manual : sudo date –set=”2015-09-30 10:05:59.990″ check timezone : date +’%:z %Z’ ganti timezone sudo vi /etc/timezone ganti menjadi Asia/Jakarta Kemudian konfigurasi ulang dengan perintah di bawah sudo dpkg-reconfigure –frontend noninteractive tzdata Current default time zone: ‘Asia/Jakarta’ Local time is now: Fri Dec 8 18:12:31 WIT 2010. Universal Time is now: Fri Dec 8… Read More »