Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. . /home/backupuser/db_credentials
  2. user=$USERNAME
  3. password=$PASSWORD
  4. dbList=$(mysql -u$user -p$password -Bse "SHOW DATABASES")
  5. for db in $dbList
  6. do
  7. mysqldump –u$user -p$password --single-transaction --routines $db > $dumpdir/${db}_${timestamp}.sql
  8. echo $db
  9. done
  10.  
  11. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
  12. db_1
  13. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
  14. db_2
  15. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
  16. db_3
  17. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
  18. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement