Advertisement
Guest User

Untitled

a guest
Sep 28th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. mysqldump --opt --all-databases -u user -pmypassword > myDump.sql
  2.  
  3. [client]
  4. password=your_pass
  5.  
  6. shell> chmod 600 .my.cnf
  7.  
  8. mysqldump --defaults-extra-file=/home/dangi/.my.cnf -u root --single-transaction --quick --lock-tables=false --all-databases (or) DATABASE | gzip > OUTPUT.gz;
  9.  
  10. [client]
  11. user=my_user
  12. password=my_password
  13.  
  14. mysql_config_editor --login-path=mysqldump --host=your_hostname --user=your_username --password
  15.  
  16. mysqldump database_name > output_file
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement