[ciapug] Re: Has anyone done the update to MySQL 5?
Mike Parks
mparks at captainjack.com
Wed Nov 2 13:40:53 CST 2005
I tried it on my server at home, going through the procedure that mysql.com
has listed. My advice "Do a complete sql dump of everything first!!!"
The problem is that some of the structure is different in 5. I ended up
trashing 4, then setting up 5 and using the SQL dump to populate it.
I'm sure I may have missed something in the instructions that mysql put on
their site?
Mike
At 12:00 PM 11/2/05, you wrote:
>Send ciapug mailing list submissions to
> ciapug at cialug.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://cialug.org/mailman/listinfo/ciapug
>or, via email, send a message with subject or body 'help' to
> ciapug-request at cialug.org
>
>You can reach the person managing the list at
> ciapug-owner at cialug.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of ciapug digest..."
>
>
>Today's Topics:
>
> 1. RE: ciapug Digest, Vol 7, Issue 1 (Wyatt, Rich)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Tue, 1 Nov 2005 12:44:30 -0600
>From: "Wyatt, Rich" <RWyatt at BSBDesign.com>
>Subject: [ciapug] RE: ciapug Digest, Vol 7, Issue 1
>To: <ciapug at cialug.org>
>Message-ID:
> <5D85EA79B7461A4CBF03E03CA709D70B3622AC at dsmmail2.BSBDesign.int>
>Content-Type: text/plain; charset="US-ASCII"
>
>Has anyone done the update to MySQL 5? I have a non-rpm installation
>and am wondering how complicated it will be to update my 4.1
>installation to 5?
>
>Rich S. Wyatt
>Webmaster
>Bloodgood Sharp Buster Architects and Planners, Inc.
>Corporate-Des Moines
>Office: 515.273.3020 Fax: 515.221.3272
>www.bsbdesign.com
>National Experience, Regional Sensitivity
>
>-----Original Message-----
>From: ciapug-bounces at cialug.org [mailto:ciapug-bounces at cialug.org] On
>Behalf Of ciapug-request at cialug.org
>Sent: Tuesday, November 01, 2005 12:00 PM
>To: ciapug at cialug.org
>Subject: ciapug Digest, Vol 7, Issue 1
>
>Send ciapug mailing list submissions to
> ciapug at cialug.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://cialug.org/mailman/listinfo/ciapug
>or, via email, send a message with subject or body 'help' to
> ciapug-request at cialug.org
>
>You can reach the person managing the list at
> ciapug-owner at cialug.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of ciapug digest..."
>
>
>Today's Topics:
>
> 1. Re: MySQL 5 released (parksmike at dwx.com)
> 2. FW: MySQL Newsletter: October 2005 (Carl Olsen)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Mon, 31 Oct 2005 16:35:45 -0600
>From: "parksmike at dwx.com" <parksmike at dwx.com>
>Subject: [ciapug] Re: MySQL 5 released
>To: ciapug at cialug.org
>Message-ID: <dbddb452528c4956876f1b1ef789734b.parksmike at dwx.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>http://www.mysql.com/news-and-events/news/article_976.html
>
>
><><><><><><><><><><><><><><><>
>Mike Parks
>
>----- Original Message -----
>From: ciapug-request at cialug.org [mailto:ciapug-request at cialug.org]
>Sent: 10/31/2005 12:00:03 PM
>To: ciapug at cialug.org
>Subject: ciapug Digest, Vol 6, Issue 10
>
> > Send ciapug mailing list submissions to
> > ciapug at cialug.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > http://cialug.org/mailman/listinfo/ciapug
> > or, via email, send a message with subject or body 'help' to
> > ciapug-request at cialug.org
> >
> > You can reach the person managing the list at
> > ciapug-owner at cialug.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of ciapug digest..."
> >
> >
> > Today's Topics:
> >
> > 1. November Meeting (Chris Hettinger)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Mon, 31 Oct 2005 09:27:02 -0600
> > From: Chris Hettinger <cjh at raccoon.com>
> > Subject: [ciapug] November Meeting
> > To: ciapug at cialug.org
> > Message-ID: <436637C6.1060101 at raccoon.com>
> > Content-Type: text/plain; charset=us-ascii; format=flowed
> >
> > Morning everyone,
> >
> > Sorry for the late reminder ... Our next meeting will be held this
> > Wednesday (Nov. 2nd) at Borders Books on University Ave. WDSM at 6 PM.
>
> > The presentation on AJAX has been postponed.
> >
> > Hope some of you new list members can make it!
> >
> > -Chris
> >
> >
> >
> > ------------------------------
> >
> > _______________________________________________
> > ciapug mailing list
> > ciapug at cialug.org
> > http://cialug.org/mailman/listinfo/ciapug
> >
> >
> > End of ciapug Digest, Vol 6, Issue 10
> > *************************************
> >
>
>
>
>------------------------------
>
>Message: 2
>Date: Tue, 1 Nov 2005 06:14:28 -0600
>From: "Carl Olsen" <carl-olsen at mchsi.com>
>Subject: [ciapug] FW: MySQL Newsletter: October 2005
>To: <ciapug at cialug.org>
>Message-ID: <004301c5dedd$cf088d30$1c00a8c0 at workstation8>
>Content-Type: text/plain; charset="us-ascii"
>
>
>
>________________________________________
>From: MySQL AB [mailto:newsletter at mysql.com]
>Sent: Monday, October 31, 2005 11:41 PM
>To: carl-olsen at mchsi.com
>Subject: MySQL Newsletter: October 2005
>
>
>MySQL Newsletter
>October 2005
>newsletter at mysql.com
>Articles in this newsletter:
>Highlights
>. MySQL 5.0 is Here! - Download MySQL 5.0 GA (Production)
>. White Paper - Inside MySQL 5.0
>. White Paper - MySQL 5.0 Pluggable Storage Engine
>. MySQL Users Conference 2006 - Call for Participation, Deadline Nov. 7
>. Vote Against Software Patents
>Products
>. New Release of MySQL 5.0.15 (GA) is Now Available
>. New Release of MySQL Connector/ODBC 3.51.12 (GA) is Now Available
>Tips & Hints
>. Documentation: What's New in 5.0
>. Article: MySQL 5.0 Archive Storage Engine
>. White Paper: A Practical Guide to Migrating to MySQL 5.0
>. Community Blogs: Excellent Blogs Dedicated to MySQL
>. A Diagram of the MySQL Information Schema
>Events
>. Live Web Seminar: MySQL 5.0's Pluggable Storage Engine Architecture,
>Oct.
>27
>. Live Web Seminar: MySQL 5.0 - Top 10 Tips to Getting Started, Nov. 3
>. Conference: Open Source Databases 2005, Nov. 8-9, Frankfurt
>. Seminar: MySQL Federal Open Source Seminar, Nov 15, Washington, DC
>. Conference: Northern European Customer Conference, Nov. 22, London
>. Community Events: MySQL User Groups
>Consulting, Training & Certification
>. Training: MySQL 5.0 for Developers (5 Days) - Save $500 - London,
>Washington DC, San Francisco Bay Area, Koeln
>. Training: MySQL 5.0 for DBAs (5 days) - Save $500 - San Francisco,
>Washington DC, London, Boston, and more
>Partner Corner
>. Arkeia - MySQL Hot Backup Solution
>. Tikal Partners with MySQL
>
>Highlights
>MySQL 5.0 is Here - Download MySQL 5.0 GA (Production)
>MySQL announced the General Availability of MySQL 5.0, the most
>significant
>product upgrade in the company's ten-year history! MySQL 5.0 delivers
>new
>advanced SQL standard-compliant features such as Stored Procedures,
>Triggers, Views & New Pluggable Storage Engines.
>Download MySQL 5.0 >
>White Paper - Inside MySQL 5.0
>MySQL 5.0 represents a huge leap forward for the world's most popular
>open
>source database. This paper first provides a technical overview of MySQL
>from the DBAs perspective, and then focuses on new features in 5.0
>Download the White Paper >
>White Paper- MySQL 5.0's Pluggable Storage Engine Architecture
>What exactly is the MySQL pluggable storage engine architecture and what
>benefits does it offer to today's modern enterprises? This paper
>addresses
>these questions and more by outlining what the MySQL pluggable storage
>engine architecture is, giving practical examples of how it works, and
>showcasing the many benefits that come from using it.
>Download the White Paper >
>MySQL Users Conference 2006 - Call for Participation - Deadline Nov. 7
>The Call for Participation is now open, and you're invited to submit a
>proposal to speak at the next MySQL Users Conference, April 24-27, 2006,
>in
>Santa Clara, California. The MySQL Users Conference brings over 1,000
>open
>source and database enthusiasts together as a celebration of the huge
>MySQL
>ecosystem. The Conference will feature a wide range of tutorials and
>sessions, including in-depth technical sessions on performance tuning,
>high
>availability, as well as PHP/Web and Data warehousing Scale-out.
>Submit a Proposal >
>Vote Against Software Patents - How You Can Help
>Please give us your vote so that Florian Mueller, the founder of the
>NoSoftwarePatents campaign, can be elected as the new "European of the
>Year". This is a campaign for a cause, not for a person. By voting for
>Florian in a public Internet poll, you can send out a strong signal that
>politicians must act against software patents.
>Learn More >
>How to Vote >
>Products
>New Release of MySQL 5.0.15 (GA) is Now Available
>This is the first production release in the 5.0 series. This release
>includes support for Stored Procedures, Views, Triggers, Information
>Schema
>(Data Dictionary), XA and more.
>For the complete list of changes visit >
>Download Now >
>New Release of MySQL Connector/ODBC 3.51.12 (GA) is Now Available
>This release is the latest production release of the 3.51 series and
>supports MySQL 4.1 and 5.0. This release was built using the MySQL v5
>client
>software and will work with any current version of the MySQL.
>For the complete list of changes visit >
>Download Now >
>Tips & Hints
>Documentation: What's New in 5.0?
>MySQL 5.0 gives developers, DBAs, and ISVs an array of new features to
>make
>you more productive developing, deploying, and maintaining industrial
>strength applications. Find out what is new in this major new release
>with
>this overview from the MySQL 5.0 documentation.
>Learn More >
>Article: MySQL 5.0 Archive Storage Engine
>More than at any other time, database professionals are being
>aggressively
>challenged by mushrooming volumes of data in corporate business systems.
>The
>Archive Storage Engine can help reduce the size of your data by more
>than
>75%.
>Read the Article >
>White Paper: A Practical Guide to Migrating to MySQL 5.0
>This paper addresses all other major questions that naturally occur when
>one
>thinks about migrating a key database-driven system to MySQL. Both the
>business and technical sides of migrating to MySQL are be discussed.
>Read the White Paper >
>Community Blogs: Excellent Blogs Dedicated to MySQL
>The MySQL Community has started excellent blogs dedicated to MySQL.
>These
>blogs include valuable tips and sample code to make you more productive.
>. Andrew Gilfrin >
>. Roland Bouman >
>. Markus Popp >
>. View all the MySQL Blogs >
>A Diagram of the MySQL Information Schema
>Roland Bouman has published the very popular "A Diagram of the MySQL
>Information Schema". It is an interactive diagram with links to the
>MySQL
>Reference Manual for more detail.
>View the Diagram >
>Events
>Live Web Seminar: MySQL 5.0's Pluggable Storage Engine Architecture
>October
>27, 2005
>One key differentiator between MySQL and other database platforms
>whether
>they are proprietary or open source - is the pluggable storage engine
>architecture of MySQL. This webinar describes what the MySQL pluggable
>storage engine architecture is, giving practical examples of how it
>works,
>and showcasing the many benefits that come from using it.
>Learn more and register today:
>. 10:00 am, Central European Daylight Time, 9:00 am GMT
>. 10:00 am PDT; 1:00 pm EDT
>Live Web Seminar: MySQL 5.0 - Top 10 Tips to Getting Started Today
>November 3, 2005: 10:00 am PST; 1:00 pm EST
>. Do you want to know how to get started with the new features of MySQL
>5.0?
>
>. Do you want to develop new database applications that use MySQL Stored
>Procedures, Triggers, Views, and Information Schema?
>. Do you want to upgrade existing applications to MySQL 5.0?
>We will discuss the new features and functionality of MySQL 5.0 and
>provide
>the Top 10 Tips to getting started with MySQL 5.0 today.
>Learn More and Register Today >
>Conference: Open Source Database Conference 2005
>November 8-9, Frankfurt, Germany
>Learn about MySQL 5.0, Using MySQL for Data Warehousing, MySQL
>Administration, and more directly from the MySQL Development Team. There
>will be 8 sessions covering MySQL at this conference.
>Register Today >
>Seminar: MySQL Federal Open Source Seminar
>November 15, 2005 - JW Marriott, Washington, DC
>Come learn why government agencies have come to rely on open source
>technology and MySQL, and what they can do for you. This seminar is free
>of
>charge. We anticipate that available space will fill up quickly, so
>register
>today!
>Register Now >
>Northern European Customer Conference
>November 22, 2005 - Hilton London, Paddington
>MySQL is pleased to announce the 1st annual Northern European Customer
>Conference on Nov 22, 2005. Please join MySQL founder, David Axmark
>along
>with MySQL technical and sales staff for a 1 day seminar, followed by a
>dinner reception.
>Learn More and Register Today >
>Community Event: MySQL Users Groups
>Meet other MySQL users in your local community and discuss the new
>features
>in MySQL 5.0. MySQL Users Groups are free and informal, face-to-face
>meetings that happen in hundreds of cities around the world. These
>meetings
>are a great opportunity to share your interest over a coffee or a beer.
>For more information and to find a user group near you >
>Consulting, Training & Certification
>Training: MySQL 5.0 for Developers (5 days) - Save $500
>London, Washington DC, San Francisco Bay Area, Koeln
>This instructor-led course is designed for students planning on
>developing
>applications that make use of MySQL 5.0. This course covers essential
>SQL
>statements for data design, querying, and programming. In addition, it
>will
>prepare students for the MySQL Developer certification.
>Register Now for an Upcoming Date >
>Training: MySQL 5.0 for DBAs (5 days) - Save $500
>San Francisco, Washington DC, London, Boston, and more
>This instructor led, hands-on class will teach you how to secure users
>privileges, set resource limitations, and access controls. In addition,
>you
>will learn new 5.0 features by creating and using Stored Procedures,
>Triggers and Views.
>Register Now for an Upcoming Date >
>Partner Corner
>Arkeia - MySQL Hot Backup Solution
>Backup of open databases is critical for many businesses which cannot
>afford
>to interrupt services relying on MySQLT, the world's most widely used
>open
>source data management tool. With that reality in mind, Arkeia developed
>solutions to fully protect MySQL application data.
>Learn More >
>Tikal Partners with MySQL
>Tikal provides ISV's with enterprise grade, fully supported open source
>Application Development & Deployment suites that lower R&D TCO and
>improve
>productivity.
>Learn More >
>About the Newsletter
>You can send us queries and give us feedback online.
>You can unsubscribe from this newsletter online or by replying to this
>e-mail with subject 'unsubscribe <carl-olsen at mchsi.com>'.
>Read more about the newsletter and view previous issues.
>
>
>Copyright C 2005 MySQL AB. All rights reserved.
>You are free to distribute this newsletter, as long as you don't make
>any
>changes.
>
>
>
>
>------------------------------
>
>_______________________________________________
>ciapug mailing list
>ciapug at cialug.org
>http://cialug.org/mailman/listinfo/ciapug
>
>
>End of ciapug Digest, Vol 7, Issue 1
>************************************
>
>
>
>NOTICE: This email (including attachments) is covered by the Electronic
>Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may
>be legally privileged. If you are not the intended recipient, you are
>hereby notified that any retention, dissemination, distribution, or
>copying of this communication is strictly prohibited. Please reply to the
>sender that you have received the message in error then delete it.
>
>
>------------------------------
>
>_______________________________________________
>ciapug mailing list
>ciapug at cialug.org
>http://cialug.org/mailman/listinfo/ciapug
>
>
>End of ciapug Digest, Vol 7, Issue 2
>************************************
<><><><><><><><><><><><><><><>
Mike Parks
Captain Jack Communications
Email: techsupport at captainjack.com
Phone: 515-964-8500
More information about the ciapug
mailing list