MySQL latest version...

  Gaz 25 23:12 22 Oct 2005
Locked

Hi..

I'm running MySQL Database server: 4.0.24

I'd like to upgrade to 4.1 versions, without loosing my databases or corrupting them.

What is the best procedure to do this?

Last time I tried, by copying the bin/data file it corrupted it, backup and export were the same. This was on an old server though, and it was an over the top install.. I think it needed a uninstall - reinstall.

Anyone suggest anything?

PS. This is a Windows Based system

Regards.

  Gaz 25 23:23 22 Oct 2005

was there something different about passwords and authentication in the new 4.1 versions?

  Forum Editor 00:45 24 Oct 2005

on a Windows machine you must stop the server.

If MySQL is installed as a service, start a command prompt and type this:-

C:\> NET STOP MySQL

Otherwise, type this:-

C:\> C:\mysql\bin\mysqladmin -u root shutdown

If you're upgrading to version 4.1.5 from a previous version, and MySQL is installed as a service, you'll have to manually remove the previous version first. To do that, type this at your command prompt:-

C:\> C:\mysql\bin\mysqld --remove

If you don't do that the installation wizard may not install the new version correctly.

Once you've installed the new version you can start the server from a command prompt by typing:-

C:\> C:\mysql\bin\mysqld --console

Needless to say, you must backup your existing databases before you do any of this.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?