Ask Daddy!! Tech Blog
Wednesday, October 18, 2017
Mysqldump command
mysqldump -uroot -p --max_allowed_packet=1024M --single-transaction --events --routines --triggers dbname | gzip -9 > dbname-full-bkp-$(date +%Y-%m-%d-%H.%M.%S).sql.gz
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment