Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqldump --opt --all-databases -u user -pmypassword > myDump.sql
- [client]
- password=your_pass
- shell> chmod 600 .my.cnf
- mysqldump --defaults-extra-file=/home/dangi/.my.cnf -u root --single-transaction --quick --lock-tables=false --all-databases (or) DATABASE | gzip > OUTPUT.gz;
- [client]
- user=my_user
- password=my_password
- mysql_config_editor --login-path=mysqldump --host=your_hostname --user=your_username --password
- mysqldump database_name > output_file
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement