Re: upgrade from 4.1 to 5.0 (novice user)

On 4/30/06, Ray <[email protected]> wrote:
> 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.

Wrong, not UNIX. This shell you mention is probably MySQL console,
available at any MySQL installation (it is the default client
application for MySQL), as mysql.exe at your bin directory (whatever
system you have).

Use DOS Prompt to launch it by issuing an:

<C:\Program Files\MySQL\MySQL Server\bin> mysql.exe -u <user> -h <host> -p

Or simply check the syntax at the Manual.

> 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.

None, you use the Mysql client (also known as console) as I mentioned above.

> please forgive errors on my part, I fought this thing till very late last
> night  :)
> Ray
>

Sorry to hear that, but we all work late at the IT world ;)

If you don't need any of the new features available at 5.0, IMHO you
should just keep you current version, security fixes and bug fixes are
still released for version 4.1.x if I'm not mistaken. I am keeping my
4 installation because I simply see no reason for an upgrade, and this
is applied at both windows and linux.

I figure I've been running stable for about an year now, so, why get
some trouble by upgrading? I mean, you may be required to upgrade
other stuff, like MyODBC, the tools you use to config/admin MySQL
database, maybe a new backup script, maybe some odd and time comsuming
operations for the upgrade,well, anyway, its just my opinion.

If you need more/any help, talk to us again.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]