sudo systemctl stop mysql
sudo killall -9 mysqld mysqld_safe
sudo systemctl stop mysql
sudo killall -9 mysqld mysqld_safe
sudo mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root
FLUSH PRIVILEGES;
UPDATE mysql.user SET authentication_string = PASSWORD('PasswordBaru123!') WHERE User = 'root';
FLUSH PRIVILEGES;
EXIT;
sudo killall -9 mysqld mysqld_safe
sudo systemctl start mysql
sudo systemctl status mysql
sudo mysqldump -u root hgdb > jkt-dbfs02_hgdb.sql
sudo mysqldump -u root hgcppmdb > jkt-dbfs02_hgcppmdb.sql
sudo mysqldump -u root hggsdb > jkt-dbfs02_hggsdb.sql
sudo mysqldump -u root hgmining > jkt-dbfs02_hgmining.sql
sudo mysqldump -u root hgmisdb > jkt-dbfs02_hgmisdb.sql
sudo mysqldump -u root sandbox > jkt-dbfs02_sandbox.sql
sudo mysqldump -u root sandboxweighbridge > jkt-dbfs02_sandboxweighbridge.sql
sudo mysqldump -u root wb_ebl_dev > jkt-dbfs02_wb_ebl_dev.sql
sudo mysqldump -u root weighbridge > jkt-dbfs02_weighbridge.sql
chmod 644 jkt-dbfs02_*.sql
scp rifki@192.168.14.32:~/jkt-dbfs02_*.sql D:\BackupMysql
backup-server (windows server)
PS C:\Users\veeam_backup> scp rifki@192.168.14.32:~/jkt-dbfs02_*.sql D:\BackupMysql
rifki@192.168.14.32's password:
jkt-dbfs02_hgcppmdb.sql 100% 3852 1.8MB/s 00:00
jkt-dbfs02_hgdb.sql 100% 34MB 105.7MB/s 00:00
jkt-dbfs02_hggsdb.sql 100% 1247 1.2MB/s 00:00
jkt-dbfs02_hgmining.sql 100% 63KB 20.5MB/s 00:00
jkt-dbfs02_hgmisdb.sql 100% 58MB 111.4MB/s 00:00
jkt-dbfs02_sandbox.sql 100% 2388 1.1MB/s 00:00
jkt-dbfs02_sandboxweighbridge.sql 100% 65KB 21.3MB/s 00:00
jkt-dbfs02_wb_ebl_dev.sql 100% 1129KB 47.9MB/s 00:00
jkt-dbfs02_weighbridge.sql 100% 357KB 23.2MB/s 00:00
PS C:\Users\veeam_backup>
- information_schema
- hgcppmdb
- hgdb
- hggsdb
- hgmining
- hgmisdb
- mysql
- performance_schema
- sandbox
- sandboxweighbridge
- sys
- wb_ebl_dev
- weighbridge