Upgrading from mysql 4.0 to 4.1 : trouble?

Started by Webrunner, February 02, 2006, 07:02:14 AM

Previous topic - Next topic

Webrunner

Hi everyone.
I just bought a new server and am installing it.
I installed a newer version of MySql (4.1.11) (comes with Debian-Sarge).
My old server has MySql 4.0.18.
Can i just copy the database files or do i need to do a conversion or check?
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy

forsakenlad

Well there may be some issues, the safest way would be to take a backup and recreate the tables by running queries ;)
Eren "forsakenlad" Yaşarkurt
SMF Friend & Former Team Member

Webrunner

I think my database is to big for that.
A backup will always be available on the old server so that won't be a problem.

I just gave it a test run and all the table i converted to InnoDB (for performance) where empty.
Maybe i will first convert them all back to MyISAM.

I read something about unicode stuff that i didn't understand.
Anyone has an idea if that is going to be a problem?
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy

H

The MySQL manual recommends a complete backup and then a complete restore when upgrading between major versions
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)
                             

Advertisement: