Text only | Text with Images

Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: Webrunner on February 02, 2006, 07:02:14 AM

Title: Upgrading from mysql 4.0 to 4.1 : trouble?
Post by: Webrunner on February 02, 2006, 07:02:14 AM
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?
Title: Re: Upgrading from mysql 4.0 to 4.1 : trouble?
Post by: forsakenlad on February 02, 2006, 07:40:35 AM
Well there may be some issues, the safest way would be to take a backup and recreate the tables by running queries ;)
Title: Re: Upgrading from mysql 4.0 to 4.1 : trouble?
Post by: Webrunner on February 02, 2006, 07:45:08 AM
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?
Title: Re: Upgrading from mysql 4.0 to 4.1 : trouble?
Post by: H on February 02, 2006, 12:19:01 PM
The MySQL manual recommends a complete backup and then a complete restore when upgrading between major versions
Text only | Text with Images