Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- . /home/backupuser/db_credentials
- user=$USERNAME
- password=$PASSWORD
- dbList=$(mysql -u$user -p$password -Bse "SHOW DATABASES")
- for db in $dbList
- do
- mysqldump –u$user -p$password --single-transaction --routines $db > $dumpdir/${db}_${timestamp}.sql
- echo $db
- done
- mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
- db_1
- mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
- db_2
- mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
- db_3
- mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
- ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement