Backup stored procedures

[elbarto]

I *think* (haven't look deeply into it) that Directadmin may not be backuping stored procedures when you create a user backup. Is it?

From what I've seen, to do this you need to run mysqldump with the --routines parameter.

Is there any way that I can modify the command Directadmin uses to do the user's mysql backup?

 

[DirectAdmin Support]

http://www.directadmin.com/features.php?id=1112

directadmin.conf:

extra_mysqldump_options=--routines

Note, if you've modified a database or table with a customization that required an elevated privilege (eg: da_admin or root), you may run into issues during the restore, since the restore doesn't run as an elevated user, for obvious security reasons. (I'm not sure if "stored procedures" fall into that category or not)

John

 

[elbarto]

Thanks!
I'll look into the privileges matter.

 

[SeLLeRoNe]

so how restore automatically the store-procedure? Should be asked as a feature request? maybe the restore process should import .sql file using da_admin account for dont mess those procedure?

Regards

 

[zEitEr]

As I can recollect, to deal with functions and procedures you should access mysql server with root/da_admin privileges. Since that, I agree with John, that's not secure to restore mysql databases with any other user, than an owner. Because, user can download mysql dump and upload one modified, and restore everything he wants.