Category Archives: MySql

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnfdibawah [mysqld] Lokasi binlog by default ada di :SHOW VARIABLES LIKE ‘log_bin_basename’;/var/lib/mysql/\xampp\mysql\data\

default value is 8 Hours (28800 Seconds):wait_timeout = 28800interactive_timeout = 28800 1 year : wait_timeout = 31536000interactive_timeout = 31536000

SP and Triggers only : time mysqldump -uroot -ppass –routines –no-create-info –no-data –no-create-db –skip-opt dbndm2 > dbndm2-sp-and-trigger-only_2021-09-10.sql Row data only :time mysqldump -uroot -ppass –skip-triggers dbndm2 > dbndm2-data-without-sp-and-trigger_2021-09-10.sql

sudo mysql_secure_installationpasswordnya : mautauajaRemove anonymous users? (Press y|Y for Yes, any other key for No) : yDisallow root login remotely? (Press y|Y for Yes, any other key for No) : yRemove test database and access to it? (Press y|Y for Yes, any other key for No) : yReload privilege tables now? (Press y|Y for Yes,… Read More »

dari computer local ssh ke server database, untuk didump ke local komputer kita : ssh system@ip-server-mysql-yg-mau-di-dump “mysqldump -uroot -ppasswordnya dbname | gzip -9” > file-local-dbname.sql.gz

create database dbbaru; mysqldump -uusernya -ppasswordnya –events –routines dblama | mysql -uusernya -ppasswordnya dbbaru

CREATE TABLE telo_copy LIKE telo_asli; INSERT INTO telo_copy SELECT * FROM telo_asli;