LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 07-23-2007, 02:18 PM   #1
rosen4o
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, 03: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).

PS:
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 03:52 AM.
 
  


Reply


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 05:14 AM
Upgrade to MySQL-5.0.18 breaks PHP mysql functions MarkVickers Slackware 5 05-03-2006 01:10 AM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 05:16 PM
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 07:43 PM
need some advices, which way is better foxele Programming 4 11-29-2004 01:42 AM


All times are GMT -5. The time now is 05:03 PM.

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