Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 07-23-2007, 01:18 PM   #1
LQ Newbie
Registered: Nov 2005
Location: Haskovo, Bulgaria
Posts: 10

Rep: Reputation: 0
MySQL upgrade advices

I have mysql 4.0 on my server. The database on the server is critical for me and I myst upgrade mysql version to mysql 5. The server is running Slackware 8.1. What advice can you give me?
Old 07-25-2007, 02:46 AM   #2
Wim Sturkenboom
Senior Member
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Read the MySQL manual. There are some hints in there. I have not done the exercise myself, so can not further advise (except the obvious one: make backups first).

Just thought of one thing:
A thing I'm aware off is that somewhere in the 4.x series the password function has changed. Version 4.0.23a still has the old function. So you have to pay attention there (the hash is longer and might not fit in the allocated space) and copying the old passwords to the new db will not work (as the hash is different). There is a way to force the old method, but not sure how.

Last edited by Wim Sturkenboom; 07-25-2007 at 02:52 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
asking for advices linwenyuan General 1 10-27-2006 04:14 AM
Upgrade to MySQL-5.0.18 breaks PHP mysql functions MarkVickers Slackware 5 05-03-2006 12:10 AM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 04:16 PM
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 06:43 PM
need some advices, which way is better foxele Programming 4 11-29-2004 12:42 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:37 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration