Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Install:
- sudo apt-get update
- sudo apt-get install mysql
- Change Password :
- mysqladmin -u root -p'new123' password '123@root'
- Backup & Restore All DB:
- mysqldump --all-databases --single-transaction --user=root --password > all_databases.sql
- Backup & Restore Single DB:
- mysql -uroot -p < database_backup.sql
- mysql -uroot -p database_name < mysql -uroot -p < database_backup.sql
- MySQL Incremental Backup
- 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