Avatar of Darko_Kantic
Darko_Kantic
Flag for France

asked on 

mysqldump , how to check for errors

I am automating backup of mysql using mysqldump, on linux. I will run the script from cron. I need a way to find out if the command has succeeded or failed. For example when I had corrupted tables the mysql dump was not backing up database and I did not know about it

I am using php to execute linux commans, so the script is PHP but command as shell, so in essence it is shell script
$command= '/usr/bin/mysqldump --add-drop-table  -h localhost -u agir2 -ppassword agir2 > '.$sql_dump_file.' > '.$errorlog.' 2>&1'
 
the problem with above code it that it does report error on failure, but on success it outputs whole database in to log file.
 
I am happy to rewrite above or just use bash script.

Open in new window

Shell Scripting

Avatar of undefined
Last Comment
Julian Parker

8/22/2022 - Mon