Mysql DB Backup command

Public

Warning message

We recommend you to assign at least one category to this snippet so you could easily navigate it in the future. Edit your snippet here.

mysqldump command by default take cares of backing the triggers but not the stored procedures.To include stored procedures in the mysql dump file use the paramter --routines with the mysqldump command

Get raw version
sql
  1. mysqldump --routines -u USER DATABASE > DATABASE.sql