Changes

Jump to navigation Jump to search
21 bytes added ,  05:03, 8 October 2019
add single transaction option
For all databases on a host
<source lang="bash">
mysql --execute="show databases" | awk '{print $1}' | grep -iv ^Database$ | sed 's/\(.*\)/mysqldump --single-transaction \1 > \1.'$(date +"%Y%m%d")'.sql/'
# Then just redo the command piped to sh
</source>

Navigation menu