Upgrading to MySQL 5.1, what do I need to know?

E

elbarto

Verified User
Joined
Oct 8, 2008
Messages
133
Hi guys...

I'm considering upgrading MySQL from 5.0 to 5.1. What do I need to take into account?

Is this as easy as changing the value in the options.conf of Custombuild and running ./build mysql?

My main concern now is related with this issue: http://www.directadmin.com/forum/showthread.php?t=30949
I have a client who needs to create/drop triggers and I'm not comfortable with giving him SUPER privilege.

But what about my other clients? What kind of problems should I expect from this upgrade?

Thanks in advance
 
from that link ive read

Starting with MySQL v5.1, there is an additional TRIGGER privilege that avoids the need of the SUPER privilege to create triggers. This one is safe.

so, you will need just to give TRIGGER privileges and not SUPER.

About the update, i would suggest you to make a backup of /home/mysql just with a normal copy like

mkdir /home/mysql_backup
cp -r /home/mysql/* /home/mysql_backup/

then use custombuild for update, and, if all is working, remove the backups... otherwise, if is not, reinstall mysql 5.0 with custombuild then check the database, if are working ok, if not.. stop mysql.. and copy back the backup
 
Code: 
# cd /home/mysql
-bash: cd: /home/mysql: No such file or directory
#
Do your systems save MySQL in /home? On which OS?

Jeff
 
always used just freebsd and debian and i alwasy founded there, didnt know other os's used different path for mysql data ^^
 
You must log in or register to reply here.
Back
Top