Backing up all databases in mysql
$ mysqldump -u root -p database-name > bkup.sql (to backup a single database)
$ mysqldump –user=root –lock-all-tables –all-databases > ${BACKUPDIR}/all-databases-${DATE}.sql
$ sleep 600
$ gzip ${BACKUPDIR}/all-databases-${DATE}.sql
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.