Advertisement
Guest User

Untitled

a guest
Feb 1st, 2017
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. Change Password :
  2. mysqladmin -u root -p'new123' password '123@root'
  3.  
  4. Backup and Restore All DB:
  5. mysqldump --all-databases --single-transaction --user=root --password > all_databases.sql
  6.  
  7. Backup and Restore Single DB:
  8. mysql -uroot -p < database_backup.sql
  9. mysql -uroot -p database_name < mysql -uroot -p < database_backup.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement