Here is my sam template for taking database backup trigger:
- none
pool:
vmImage: ubuntu-latest
steps:
- script: echo Hello, world!
displayName: 'Run a one-line script'
- script: |
sudo apt-get -f install -o Dpkg::Options::="--force-overwrite"
sudo apt-get update
sudo apt-get purge mysql\*
rm -rf /var/lib/mysql
rm -rf /etc/mysql
dpkg -l | grep -i mysql
sudo apt-get clean
updatedb
sudo apt-get install mysql-client
displayName: 'Getting Mysql Client'
- script: |
mysql -V
displayName: 'Displaying Mysql Client version'
- script: |
mysqldump -h host --triggers --routines -u username --password="password" -P 3306 SDA_RMA_DE > dev_sda_db_bkp_test.sql
displayName: 'Taking Backup'
When I try running pipeline it got failed in taking backup step mysqldump:
Got error: 2003: Can't connect to MySQL server on 'host' (110) when trying to connect
Please help me by saying how to overcome this error