minte9

LearnRemember

Conf

Dump mysql database in script without providing the password.

 
cd ~/
sudo touch .my.cnf

[mysqldump]
host=myhost
port=3306
user=mysqluser

 
sudo mysqldump 'mydbhost' 'mydb' -v > /var/www/html/mydb.sql    

Cron

 
sudo gedit /etc/crontab

 
00 18 * * * root mysqldump 'mydbhost' 'mydb' > /var/www/html/mydb.sql        
    #not working

Cron status

 
sevice cron status
    

https://askubuntu.com/questions/85558/verify-if-crontab-works https://askubuntu.com/questions/222512/cron-info-no-mta-installed-discarding-output-error-in-the-syslog

Error No MTA installed

Most Linux distributions have a mail service including an MTA (Mail Transfer Agent) installed. Ubuntu doesn't.

 
sudo apt-get postfix    
    #choose 'Local'
    

Debug

 
sudo tail -f /var/mail/root
    

Resume

 
cd ~/
sudo touch .my.cnf

[mysqldump]
     host=myhost
     port=3306
     user=mysqluser
     password=mypass

chmod 0600 .my.cnf
chown catalin.catalin .my.cnf

mysqldump 'mydbhost' 'mydb' > /var/www/html/mydb.sql 
    #testing mysqldump

sudo gedit /etc/crontab

    00 18 * * * catalin mysqldump 'mydbhost' 'mydb' > /var/www/html/mydb.sql

service cron status
tail -f /var/mail/catalin
    #look for errors