Upgrade Mysql

------=_NextPart_000_0009_01C9D935.A125C170
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

I need to upgrade Mysql 4 to Mysql 5 on Linux.

=20

I will uninstall version 4 and install version 5.

=20

=20

With uninstallation usually database files remain in /var/lib/mysql/

=20

=20

=20

I want to know if with the installation of Mysql 5 those database will =
be "recognized and imported" to work with the new version automatically.

=20

=20

=20

Thank You.
------=_NextPart_000_0009_01C9D935.A125C170--

Re: Upgrade Mysql

On May 20, 2009, at 1:27 AM, Webmaster Studio Informatica wrote:

> I need to upgrade Mysql 4 to Mysql 5 on Linux.

Sometimes....

> I will uninstall version 4 and install version 5.
>
> With uninstallation usually database files remain in /var/lib/mysql/
>
> I want to know if with the installation of Mysql 5 those database
> will be "recognized and imported" to work with the new version
> automatically.

In most cases, but you should have a database dump of all of them just
in case. You do not specify what version of 4 you are at.

You need to at least read this:
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.ht ml

Specifically look at "Incompatible change", there are quote a few.
Most will not bother you. For me, the biggest issue was my use of
timestamp, and how that changed a bit. Luckily I had a function that
I used in my code to format that timestamp value, so it was just a
matter of going through all my code and updating one function to all
sites.

This was also only a display issue for me and did not change my data.

You do have to know your code. If you do not, I would use a staging
server, and do them one database at a time, test, make sure it works,
and go from there.
--
Scott * If you contact me off list replace talklists@ with scott@ *


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Upgrade Mysql

On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote:
> Hi,
>
>
>
> I need to upgrade Mysql 4 to Mysql 5 on Linux.
>
>
>
> I will uninstall version 4 and install version 5.
>
>
>
>
>
> With uninstallation usually database files remain in /var/lib/mysql/
>
>
>
>
>
>
>
> I want to know if with the installation of Mysql 5 those database will be "recognized and imported" to work with the new version automatically.
>
>
>
>
>
>
>
> Thank You.
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>

Your best path is to

If 4.0,

Compile 4.1

Follow upgrade procedure


If 4.1

Compile 5.0

Follow upgrade procedure

If 5.0

Compile 5.1

Follow upgrade procedure.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Upgrade Mysql

Hi,

I don't know what Linux distro you're using, but I'd make a backup of
/var/lib/mysql dir before you do anything (in case the mysql package
decides to nuke your stuff). If you have a dump of your dbs, that's fine
too. And maybe a backup of your my.cnf.

Just install the new mysql package, then start it. Then you'll need to
run "mysqlupgrade". Depending on the size of your database and type of
tables you are using it can take a while. For InnoDB tables, for
example, upgrade simply means copy to tmp table... that's really slow if
you have a large table.

Once mysqlupgrade runs without a hitch, you should be back in business.

-Paul


Webmaster Studio Informatica wrote:
> Hi,
>
>
>
> I need to upgrade Mysql 4 to Mysql 5 on Linux.
>
>
>
> I will uninstall version 4 and install version 5.
>
>
>
>
>
> With uninstallation usually database files remain in /var/lib/mysql/
>
>
>
>
>
>
>
> I want to know if with the installation of Mysql 5 those database will be "recognized and imported" to work with the new version automatically.
>
>
>
>
>
>
>
> Thank You.
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org