Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2017
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. Install:
  2. sudo apt-get update
  3. sudo apt-get install mysql
  4.  
  5. Change Password :
  6. mysqladmin -u root -p'new123' password '123@root'
  7.  
  8. Backup & Restore All DB:
  9. mysqldump --all-databases --single-transaction --user=root --password > all_databases.sql
  10.  
  11. Backup & Restore Single DB:
  12. mysql -uroot -p < database_backup.sql
  13. mysql -uroot -p database_name < mysql -uroot -p < database_backup.sql
  14.  
  15. MySQL Incremental Backup
  16. mysqldump -h $HOST -u $DB_USER -p$DB_PASSWORD --single-transaction --quick $DB_NAME_EWO |gzip > /home/ubuntu/database_backup/$BACKUP_FOLDER/$DB_NAME_EWO-$NOWDATE.sql.gz
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement