Untuk backup MySQL dapat menggunakan mysqldump
mysqldump -e –u [username] -p [password] -h [hostname] [database name] > [filename].sql
Untuk backup semua database:
sudo mysql -u root -N -e 'show databases where `Database` not in("information_schema","performance_schema","phpmyadmin")' | while read dbname; do sudo mysqldump -u root --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname"_$(date +%Y%m%d_%H%M%S).sql; done
Untuk restore MySQL Database dapat menggunakan command berikut:
mysql -u username -p database_name < backup_name.sql
Users Today : 161
Users Yesterday : 135
This Month : 3095
This Year : 46370
Total Users : 58433
Views Today : 345
Total views : 155534
Who's Online : 6
Recent Comments