2,187
edits
Difference between revisions of "Backup MySQL (Ubuntu)"
Jump to navigation
Jump to search
m
→The Script: Typo in script - fixed
m (Added GRANT for backup user) |
m (→The Script: Typo in script - fixed) |
||
| Line 80: | Line 80: | ||
else | else | ||
# Is backup required? | # Is backup required? | ||
DBUPDATE=`mysql -u | DBUPDATE=`mysql -u $MUSER -h $MHOST -p$MPASS -Bse "SELECT max(update_time) FROM information_schema.tables WHERE table_schema='${db}'"` | ||
DBUPDATEU=`date --date "${DBUPDATE}" +%s` | DBUPDATEU=`date --date "${DBUPDATE}" +%s` | ||
#Logger "$db last update was $DBUPDATE" | #Logger "$db last update was $DBUPDATE" | ||