Home | Articles | About | Contact | Forum |
Friday, October 18, 2019

Lunarpages.com Web Hosting

Mailing List

By Joining the mailing list you will be notified of site updates.

Show Your Support For
This Site By Donating:

Audience: System Admins - I.T. Managers
Last Updated: 3/21/2009 9:16:46 PM
Original Creation Date: 5/17/2009 3:16:46 PM
**All times are EST**

HOWTO - mySQL: Upgrade Version on Windows

By Erik Rodriguez

This article provides information on how to effectively upgraded mySQL from version 5.0 to 5.1 on a Windows platform.

I'm not an expert with mySQL by any means. :oops: I use it primarly on Linux so I was a little confused about how to do an upgrade on a Windows server.

I browsed around google and the mySQL documentation, but was still not sure what to expect.  I had version 5.0.x installed and needed to utilize a function in 5.1.x that wasn't present in previous versions.  Here are the steps for upgrading:
  1. Backup your databases!!!
  2. Download the new package
  3. Install the new package*
  4. Restore your backup
  5. Readd the users
  6. Reset the user permissions
*The important thing to mention here is that SQL 5.1 WILL NOT install over the top of 5. It will create another directory and instance under C:/Program Files/MySQL. You cannot have the two running at the same time unless you change the port they listen on.

The first time I did this upgrade, nothing worked because the users are part of the SQL backup.  The new instance of mySQL WILL replace the Windows service so you will not be able to start 5.0 automatically anymore.  The workaround if you need it is to start the old version manually from the command line.  To do so:
cd to:

C:\Program Files\MySQL\MySQL Server 5.0\bin\

run this:

mysqld-nt.exe --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
So, if you have you documentation of your user credentials, you should be able to successfully complete the upgrade. The process makes this more of a migration to a new version than an upgrade, but following these steps should work just fine.

Juniper SRX anti-spam filtering config
Windows Server 2008 Clustering Configuration
Windows 2008 R2 Network Load Balancing (NLB)
Extreme Networks: Downloading new software image
Juniper SRX save config to USB drive
Juniper SRX logout sessions
Extreme Networks Syslog Configuration
Command line drive mapping
Neoscale vs. Decru
Data Security vs. Data Protection
Juniper SRX Cluster Configuration
HOWTO - Create VLAN on Extreme Switch
Using a Non-local Colocation Facility
Linux Server Administration
IT Chop Shops
Flow Viewers: SFLOW, NetFLOW, and JFLOW
Exchange 2007 Back Pressure
IPtables open port for specific IP
Politics in IT Departments
HOWTO - Block Dropbox
Cisco IOS Cheat Sheet
Subnet Cheat Sheet
Design a DMZ Network
How DNS works
Firewall Configuration
Juniper SSG Firewalls
Server Management
Configuring VLANs
Runlevels in Linux
Server Clustering
SONET Networks
The Red Hat Network
Server Colocation
Complicated Linux Servers
Dark Fiber
Data Center Network Design
Firewall Types
Colocation Bandwidth

Copyright © 2002-2016 Skullbox.Net All Rights Reserved.
A division of Orlando Tech Works, LLC
By using this site you agree to its Terms and Conditions.
Contact Erik Rodriguez