Archives : March-2020

MSSQL Backup, Stop service ESMC sebelum melakukan backup buka RUN ketik service.msc untuk panduan lengkap disini 1. Open PowerShell run as administrator dan jalankan perintah berikut : Perintah Backup : SQLCMD -S localhost\ERASQL -q “BACKUP DATABASE ERA_DB TO DISK = ‘C:\ESET\ddmmyy.bak'” Perintah Restore : SQLCMD -S localhost\ERASQL -q “RESTORE DATABASE ERA_DB FROM DISK = ‘C:\ESET\ddmmyy.bak'” ..

Read more

Backup database Mysql dan restore database lakukan stop service eraserver systemctl stop eraserver 1. Perintah backup Database :mysqldump –host localhost –disable-keys –extended-insert –routines -u root -p nama_db > namafilebackup.sql 2. Proses restore DB lihat isi database mysql #Login Database mysql -u root -p #Masuk di dalam Mysql Show database show databases; # Remove databasedrop database ..

Read more