From: "Steven Levine" <ecs-isp@2rosenthals.com>
Message-ID: <64d27fce.4.mr2ice.fgrirsq@earthlink.net>
Date: Tue, 08 Aug 2023 10:47:58 -0700
To: "eCS ISP Mailing List" <ecs-isp@2rosenthals.com>
In-Reply-To: <list-7601707@2rosenthals.com>
Subject: Re: [eCS-ISP] mysql upgrade 5.1.73 -> 5.6.51

In <list-7601707@2rosenthals.com>, on 08/08/23
   at 09:07 AM, "Massimo S." <ecs-isp@2rosenthals.com> said:


Hi,

>is there any other way?

There are always other ways.  Some are more or less work than others. 
Some are more or less error prone than others.

>i don't have perl running on the VM
>i'm not testing 5.6.51 on the VM db machine, that only runs mysql

You can always create a temporary VM just to do the upgrade and then copy
the files to the production machine once you are satisfied they are
production ready.  This is how most of us work to avoid unexpectedly
taking down a production machine.

>the 5.1.73 DB machine dump all DBs each night during bkups

That's like saying Tuesday occurs once a week.  It does not tell mean
anything I don't already know.  Now, if you told us you never backed up
the DBs, that would be unexpected.

How are you dumping the DB, using what mysql commands?

Steven

-- 
----------------------------------------------------------------------
"Steven Levine" <steve53@earthlink.net>  Warp/DIY/BlueLion etc.
www.scoug.com www.arcanoae.com www.warpcave.com
----------------------------------------------------------------------