upgrade from 4.1 to 5.0 (novice user)

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

these pages also seem relevant:
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.htm l
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/win32?unsub=gcdmw-win32@m.gmane.org

Re: upgrade from 4.1 to 5.0 (novice user)

On 4/30/06, Ray 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 w=
e
> have to. I have just updated all the software on a win 2003 server, excep=
t
> 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 :) )bu=
t
> I'm having a problem following it.
> http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.ht ml
>
> these pages also seem relevant:
> http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.htm l
> 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 shoul=
d
> 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 ver=
y
> 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:

mysql.exe -u -h -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/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: upgrade from 4.1 to 5.0 (novice user)

Hi,

My first policy.
If it aint broke, *never* fix it unless, the new version has new
features you want to use (and you cannot find a work around), or the old
version has bugs that the new version addresses. Another good thing
would to let the new version be used by other people for a couple of
months before doing an upgrade... let the others test it for you

Ray 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.ht ml
>
> these pages also seem relevant:
> http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.htm l
> 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/win32?unsub=gcdmw-win32@m.gmane.org

RE: upgrade from 4.1 to 5.0 (novice user)

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

It's very much the case. We are still running v 3.23 on our production se=
rvers, simply because there is no real need to upgrade.
There's a couple of gotchas when upgrading, too. The exact version number=
s escape me at the moment (I think it was from 3.x to 4.x), but a lot of p=
eople got caught by the new authentication scheme when upgrading. All of a=
sudden their remote clients couldn't connect, because the old client wou=
ldn=92t talk to the new server. These and other non-obvious things are us=
ually a good reason not to upgrade unless you specifically want features a=
vailable in the new version.

As far as your backup goes, I would recommend scripting it. Table locks a=
re a tricky beast sometimes, and it would be for more difficult and time-=
consuming to do it manually. Also, have a look at the mysqlhotcopy facili=
ty. It may or may not do what you want, but much faster.
Standard disclaimer applies here: This is just my opinion, others may beg=
to differ.

Regards,
Leigh
=20
Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

-----Original Message-----
From: Ray [mailto:ray@media32.ca]=20
Sent: Monday, May 01, 2006 8:36 AM
To: win32@lists.mysql.com
Subject: upgrade from 4.1 to 5.0 (novice user)

hello,
I hope this is the right place to ask this question. (I couldn't find a n=
ovice 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, exce=
pt 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 :) )bu=
t I'm having a problem following it.=20
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.ht ml=20

these pages also seem relevant:
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.htm l
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 shoul=
d I do this update. Is this new version important, or is it a case of, "I=
f it ain't broke, don't fix it"?

this server has about a dozen databases with around the same number of da=
tabase users. =20
I tried to follow the instructions on the pages indicated above, with ver=
y limited success.=20
I find that much of the user documentation gives commands to be issued fr=
om 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 tab=
les...". Lock tables is a SQL command (right?) but from where? do I need t=
o write a script to do the backup, or do I issue the commands from PhpMyA=
dmin or ...? any pointers on how to do this would be very much appreciate=
d.
please forgive errors on my part, I fought this thing till very late last=
night :) Ray=20



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwi=
reless.com.au



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: upgrade from 4.1 to 5.0 (novice user)

On 5/1/06, Jangita wrote:
> Hi,
>
> My first policy.
> If it aint broke, *never* fix it unless, the new version has new
> features you want to use (and you cannot find a work around), or the old
> version has bugs that the new version addresses. Another good thing
> would to let the new version be used by other people for a couple of
> months before doing an upgrade... let the others test it for you
>

In order to migrate from 4 to 4.1 (where the password format changed,
along with some other incompatible changes), I created a mirror of my
server and choose a few days to test it (low usage). While doying
this, I binary logged all information so I could repeat it (now I
think of why haven't used replication, duhhh). The migration went with
a few problems, but nothing too big.

--
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/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: upgrade from 4.1 to 5.0 (novice user)

Comments inline...

> -----Original Message-----
> From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> Sent: Monday, May 01, 2006 5:41 PM
> To: ray; win32
> Subject: RE: upgrade from 4.1 to 5.0 (novice user)
>
>
> >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"?

In some cases it's better to say 'if it ain't broke, break it.'


> It's very much the case. We are still running v 3.23 on our

This has vulnerabilities to you and your clients.

> production servers, simply because there is no real need to upgrade.

Actually yes there are real reasons to upgrade to at least 4.1.x

> There's a couple of gotchas when upgrading, too. The exact

Always.


> version numbers escape me at the moment (I think it was from
> 3.x to 4.x), but a lot of people got caught by the new
> authentication scheme when upgrading. All of a sudden their

Yes, many folks didn't realize that this new scheme would have a serious
impact. You can either keep the old auth.scheme in place or update your
users to the new scheme. I recommend the latter.
If you review the upgrading from 3.x to 4.x document in the manual it will
explain your options in a clearer fashion than my brain can recall.

> remote clients couldn't connect, because the old client
> wouldn't talk to the new server. These and other non-obvious
> things are usually a good reason not to upgrade unless you
> specifically want features available in the new version.

Well there are many other reasons one may wish to upgrade also, but you need
to decide for yourselves whether it's worth it or not for you. But moving
away from unsupported versions like 3.x or 4.0 is very wise.

> As far as your backup goes, I would recommend scripting it.
> Table locks are a tricky beast sometimes, and it would be for
> more difficult and time-consuming to do it manually. Also,
> have a look at the mysqlhotcopy facility. It may or may not
> do what you want, but much faster.
> Standard disclaimer applies here: This is just my opinion,
> others may beg to differ.

I have done it differently myself, but I can attest that this tool works
well also.

>
> Regards,
> Leigh
>
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email lsharpe@pacificwireless.com.au
> web www.pacificwireless.com.au
>
> -----Original Message-----
> From: Ray [mailto:ray@media32.ca]
> Sent: Monday, May 01, 2006 8:36 AM
> To: win32@lists.mysql.com
> Subject: upgrade from 4.1 to 5.0 (novice user)
>
> 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.ht ml
>
> these pages also seem relevant:
> http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.htm l
> 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/win32?unsub=lsharpe@pacificwireless.c om.au
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=lucretias@shaw.ca
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org