Changes

Mysqldump (view source)

Revision as of 05:03, 8 October 2019

21 bytes added , 05:03, 8 October 2019

add single transaction option

For all databases on a host

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>

Admin

Image-reviewer, Bureaucrats, Check users, confirmed, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Editors (Semantic MediaWiki), staff, Suppressors, sysadmin, Administrators, uploadaccess, Upload Wizard campaign editors, Widget editors

1,549

edits