mysql stored procedures.

[jefvv]

Hi all,

Is there a feature in directadmin backing up stored procedures from mysql,
these are stored in mysql/proc but are not restored after admin backup/restore..

if not, might this be an option to be build into directadmin.

regards
Jef van Verseveld
CSV-Networks

 

[DirectAdmin Support]

Hello,

Because the creation of procedures requires super privilege, and the restore loads an sql file without such access, thus this would not be possible.

If the sql files are restored with super privilege, full access to mysql would be possible with the restore, which would be very insecure (eg: a User could simply add any sql statement he wanted, restore the backup, and have full control over everyone's databases)

If you had manually created a procedure with super privilege in the first place, you'd have to repeat the same thing again. DA does not backup or restore mysql items that require super privileges to install. (except databases, User accounts, access hosts, etc..)

John

 

[jefvv]

Hi john,

thanks for your reply clearing it up, it's just something that happened to one of our customers, and it made me wonder about it.

regards,
Jef

 

[Raimo]

I have customers that have been on the same server from day 1. The customers have been give an empty virtual server with DA where they have uploaded their files and databases.
I have not given the SUPER privilege manually to them, but they are still able to add procedures to the MySQL database.

I need to figure out how is that possible, because it's creating problems when moving customer to new servers.

They do have SSH access if it's relevant.

 

[Michael Caine]

You can save them as file in harddisk like queries and reload them.