Author Archives: ballacksave

default value is 8 Hours (28800 Seconds):wait_timeout = 28800interactive_timeout = 28800 1 year : wait_timeout = 31536000interactive_timeout = 31536000

SP and Triggers only : time mysqldump -uroot -ppass –routines –no-create-info –no-data –no-create-db –skip-opt dbndm2 > dbndm2-sp-and-trigger-only_2021-09-10.sql Row data only :time mysqldump -uroot -ppass –skip-triggers dbndm2 > dbndm2-data-without-sp-and-trigger_2021-09-10.sql