How To Take Backup Of Mysql Database & Restore





Backup database Mysql dan restore database

Perintah backup Database :
mysqldump --host localhost --disable-keys --extended-insert --routines -u root -p nama_db > namafilebackup.sql

lihat isi database mysql
#Login Database
mysql -u root -p

#Masuk di dalam Mysql Show database
show databases;

# Remove database
drop database data_db;

#Create database

Create database namadatabase_db;

#Perintah Restore database
mysql --host localhost -u root -p namadatabse_db < namafilebackup.sql


gambar dari : https://pngimg.com/imgs/logos/mysql/

0 Comments