upgrade from 4.1 to 5.0 (novice user)

"Ray" <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
hello,
I hope this is the right place to ask this question. (I couldn't find a
novice list) I am more of a programer than system admin, but we do what we
have to. I have just updated all the software on a win 2003 server, except
I couldn't figure out how to update MySQL, or more accuratly, I couldn't
figure out how to restore the data after a program update.
I found the following page (wasn't hard, it's on the download page :) )but
I'm having a problem following it. 
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html 

these pages also seem relevant:
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.html
http://dev.mysql.com/doc/refman/5.0/en/backup.html

I guess before I go any farther, the first question I should ask is should
I do this update. Is this new version important, or is it a case of, "If
it ain't broke, don't fix it"?

this server has about a dozen databases with around the same number of
database users.  
I tried to follow the instructions on the pages indicated above, with very
limited success. 
I find that much of the user documentation gives commands to be issued
from  shell>  (unix right?) and I'm not sure how this applys to windows.
Also instructions are given like "...do a LOCK TABLES on the relevant
tables...". Lock tables is a SQL command (right?) but from where? do I
need to write a script to do the backup, or do I issue the commands from
PhpMyAdmin or ...? any pointers on how to do this would be very much
appreciated.
please forgive errors on my part, I fought this thing till very late last
night  :)
Ray 



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.