stored procedures & trigers in powweb

[doblexl]

Hello,

im creating a new version of my database in powweb and i want to use triggers and stored procedures.

phpmyadmin doesn't support this feature and im searching another tool that i can install in powweb to access to my bd that support it.

Does Anyone kwows any application?

Thanks

[HalfaBee]

I don't think powweb grants access to the procedures/functions in mysql5.

I tried this simple test and it didn't work.
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) NO SQL RETURN CONCAT('Hello, ',s,'!');

error message
You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

[doblexl]

yes. i tried to create a trigger and get the same error.

I don't understand this. We are not able to use the posibilities of mysql 5.0 that it's installed. Well, i will continue without this feature.

Thanks for all.

[HalfaBee]

Procedures, triggers & functions are mysql intensive. On shared hosts it is probably not a good idea to enable them.

queries on the information_schema DB are very slow, so doing things via php is more likely to be more reliable.

[TrixxRI]

Procedures, triggers & functions are mysql intensive. On shared hosts it is probably not a good idea to enable them.

queries on the information_schema DB are very slow, so doing things via php is more likely to be more reliable.

You're not kidding...
I happen to use a 3rd party GUI from my laptop to manage my databases. It provides a secure method to relay via the website so I don't need to worry about inbound mysql connectivity. However since the upgrade I've noticed the "start up" time, when it is downloading the table information and details - just plain hangs and blocks on a reply from the database. I never had this issue before with mysql4 and I will also chime in at this point, what was the purpose of upgrading to mysql5 if we are not seeing either performance boosts or incremental changes in functionality.

Personally I would have been happier to see SFTP access added first. It's not necessary to allow shell access in order to allow SFTP, and I'm sure most of those who have done unix admin know, just like with FTP access to certain /bin files are needed in a chroot environment so not much difference.

[dmacminn]

1) MySQL Version 4 support will soon be discontinued ... we need to be current to get support from MySQL AB.
2) MySQL 5 has better control functions for limiting connections (this is 95.9% of the reason we needed to implement it).
3) It does have some other features (like stored procedures, etc) that may be possible once additional changes are made...
4) Its been out about two years ... isn't it just about time (mind you, I still run Win2000 at home!)...