Guest User

Untitled

a guest
Sep 15th, 2018
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. #mysql-backup
  2. mysqldump -h localhost –u root –p myrootpassword db_name > db_test.sql
  3.  
  4. #for multiple database
  5. mysqldump -h localhost –u root –p myrootpassword db_name1 db_name2 > db_test.sql
  6.  
  7. #for all table
  8. mysqldump -h localhost –u root –p myrootpassword -all-databases > db_test.sql
  9.  
  10. #for specifiec table
  11. mysqldump --user root --password=myrootpassword db_test customers \ > db_test_customers.sql
  12.  
  13. #restoring
  14. mysql --user root --password=myrootpassword new_db < db_test.sql
  15.  
  16. #reset password
  17. sudo su
  18. /etc/init.d/mysql stop
  19. mysqld_safe --skip-grant-table --user=root
  20. mysql -u root -p
  21. UPDATE mysql.user set Password=PASSWORD('passwordbaru') WHERE user='root';
  22. flush privileges;
  23. exit;
  24. /etc/init.d/mysql restart
Add Comment
Please, Sign In to add comment