Perintah SQL Lanjutan

MEMBERIKAN HAK AKSES :

mysql> GRANT ALL PRIVILEGES

-> ON namadatabase.*

-> TO sani@localhost

-> IDENTIFIED BY 'password';

MEMBERITAHU KE SISTEM MYSQL :

mysql> FLUSH PRIVILEGES;

BACKUP DATABASE :

/mysqldump -u root -p NamaDatabase > /home/siswa/namafile.sql

RESTORE DATABASE:

1. Buat database kosong,ex : dblatihan
2. restore → mysql -u root -p dblatihan < lokasi&nama file yang sudah di backup