Hi, Step by step how to:
1. Stop mysql service i.e. /etc/init.d/mysql stop, confirm with "ps auxw| grep -i mysql" command. 2. Find old installed rpms and remove - rpm -qa | grep MySQL, remove old rpms - "rpm -e --nodeps MySQL-xxx-xxxx MySQL-xxx XX XX" 3. Safe copy of old mysql - cd /var/lib/; cp -rp myql orig_mysql; mv mysql mysql_5_0 4. install mysql-5.1 5. Stop mysql service - /etc/init.d/mysql stop, confirm with "ps auxw| grep -i mysql" command. 6. Cleanup directories from orig_mysql - cd /var/lib/orig_mysql/; rm -rf *.err *.pid plugins test mysql 7. Cleanup innodb files from newly installed mysql and move data from orig_mysql to mysql - cd /var/lib/mysql; rm -f ib*; mv ../orig_mysql/* ./; chown -R mysql:mysql * 9. Start mysql and run force upgrade- /etc/init.d/mysql start; mysql_upgrade --force Regards, ./Zakir On Fri, Feb 12, 2010 at 3:39 PM, dinesh jadhav <[email protected]>wrote: > > > Hi All, > > I want to upgrade mysql 5.0 to mysql 5.1. I tried lot it is asking > dependecies after installed dependencies again mysql crashed, > > Could you send wiki how to upgrade mysql > > Linux Don > Dinesh Jadhav(RHCE) > 9867011640 > > "Do not worry about anything; instead > PRAY ABOUT EVERYTHING." > Philippians 4:6 > http://dineshjadhav.wordpress.com > http://mm.glug-bom.org/mailman/listinfo/linuxers > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
