Home Database Backup MySQL Stored Procedures and Functions

Who's Online

  • [Bot]
Now online:
  • 1 guest
  • 1 robot
Latest members:
  • Glasttrarne
  • Nikhilbhave

Statistics

Content View Hits : 15625

Do You Know ?

PLML - Public Land Mobile Network
Backup MySQL Stored Procedures and Functions

mysqldump take the backup by default  all the triggers but NOT the stored procedures and functions.  We can solve this issue with  2 mysqldump parameters:

  • –routines - FALSE by default
  • –triggers - TRUE by default

It means that if we want to include in an existing backup script also the triggers and stored procedures we only need to add the –routines command line parameter:

mysqldump --routines <databasename>  > backup.sql 
 
 
keywords
job title or skills
location
city, state or zip
Jobs by SimplyHired
Banner