List:General Discussion« Previous MessageNext Message »
From:Ben Ricker Date:May 18 2004 8:13pm
Subject:Re: Running more than one level of MySQL
View as plain text  

I just did an upgrade from 3.23.54a to 4.0.18 for 4 DB servers. It was a
piece of cake. Some hints:

1) Run through the docs on changes from previous versions. Someone who
understands the DBs you will be moving would be helpful to look at it  as

2) that stuff about "security settings" is baloney. The higher the version,
the more likely you are to have a MORE secure MySQL as they apply security
and bug fixes to the later versions.

3) I ran both versions side-by-side listening on different ports. We did
all the testing we needed on the different port and then all we had to do
was bring down the old and bring up the new on the old port.

4). You will have some down time to do exports of the old database and to
import to the new one. We used a mysqldump --opt --all-databases and then
imported it after taking down the front-end. When it came back up, it was
working transparently.

Good luck.

Ben Ricker


Ben Ricker
Web Administrator
Mastercard International, Inc.
904 North Third
(636) 722-4697

                      "Robert A.                                                          
                      Rosenberg"               To:       mysql@stripped            
                      <MySQL@stripped        cc:       (bcc: Ben
                      >                        Subject:  Running more than one level of
                      05/18/2004 02:46                                                    

I have a site that is being hosted by an ISP which is running version
3.23.52. When I questioned why that downlevel version and not a 4.0
version (such as 4.0.18 or the just released 4.0.20), I was told
"Unfortunately, when versions change on MySQL, they also drop
features and change security settings. This can cause many problems
system wide." Before I go further with my discussion and renew my
request for a 4.0 Database, I would like to know if it is even
possible to have more than one level active (and if so, what is
involved in the set-up).

Thank you.

MySQL General Mailing List
For list archives:
To unsubscribe:

This e-mail message and any attachments are only for the use of the intended recipient and
may contain information that is privileged, confidential or exempt from disclosure under
applicable law.  If you are not the intended recipient, any disclosure, distribution or
other use of this e-mail message or attachments is prohibited.  If you have received this
e-mail message in error, please delete and notify the sender immediately. Thank you.

Running more than one level of MySQLRobert A. Rosenberg18 May
  • Re: Running more than one level of MySQLPaul DuBois18 May
    • Re: Running more than one level of MySQLRobert A. Rosenberg19 May
      • Re: Running more than one level of MySQLDan Nelson19 May
Re: Running more than one level of MySQLBen Ricker18 May