Home > Archive > MySQL ODBC Connector > January 2006 > need to upgrade









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author need to upgrade
Jon Miller

2006-01-01, 8:23 pm

I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise =
9.2 or Debian 3.1 server. I understand that the only way to get the data =
from the RH7.2 server is via mysqldump. Are there any gotchas or issues =
doing this?

Thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

John in Pueblo

2006-01-01, 8:23 pm

On Sunday 01 January 2006 6:44 pm, Jon Miller wrote:
> I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2
> or Debian 3.1 server. I understand that the only way to get the data from
> the RH7.2 server is via mysqldump. Are there any gotchas or issues doing
> this?



all right, basically, what you just said was the equivalent of "I want to
upgrade my Office 1997 to Windows XP". Don't you mean you need to transfer
your dbs from one server to another.
--
Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar?
Fletch: I don't know. I don't have any.
Dr. Joseph Dolan: No children?
Fletch: No, elephant books.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

John Trammell

2006-01-03, 9:23 am

The online documentation would be a good place to start.

http://dev.mysql.com/doc/refman/4.1/en/upgrade.html=20

> -----Original Message-----
> From: Jon Miller & #91;mailto:jlmiller@
mmtnetworks.com.au]=20
> Sent: Sunday, January 01, 2006 7:44 PM
> To: mysql@lists.mysql.com
> Subject: need to upgrade
>=20
> I need to upgrade MySQL from a RH7.2 server to either a Suse=20
> Enterprise 9.2 or Debian 3.1 server. I understand that the=20
> only way to get the data from the RH7.2 server is via=20
> mysqldump. Are there any gotchas or issues doing this?
>=20
> Thanks
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =20
> http://lists.mysql.com/mysql? unsub...
corp.com

>=20
>=20



INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR T=
HE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE=
=2E If you are not an intended recipient of this message, or an agent res=
ponsible for delivering it to an intended recipient, you are hereby notif=
ied that you have received this message in error, and that any review, di=
ssemination, distribution, or copying of this message is strictly prohibi=
ted. If you received this message in error, please notify the sender imme=
diately, delete the message, and return any hard copy print-outs.=0A=0ATh=
is message has been scanned for viruses by McAfee's Groupshield.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Imran Chaudhry

2006-01-03, 1:23 pm

Yes, potentially there are "gotchcas". It all depends on your current
MySQL server version and the version you are upgrading to.

Assuming you are upgrading 3.23 to 4.0, what I would do is look at the
official documentation regarding upgrades from exactly this scenario:
http://dev.mysql.com/doc/refman/4.1...-from-3-23.html

I think you'll find the upgrade pretty painless from a data point of
view, but you will need to heed the changes to the GRANT tables.

Imran Chaudhry

--
http://www.EjectDisc.com
Get your Digital Identity - Domain Names, Web Space, E-mail & More!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com