View Single Post
  #3  
Old 09-02-2019, 12:25 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

This is just me, doing things manually all the time, but using the --routines backs up the views and functions as well.
Example: (assuming "peq" is name of database, and "*****" is db password") :
mysqldump --routines -u root -p***** peq > peq_backup.sql
__________________
Hanging out at Antonica.World
Reply With Quote