Advertisement:

Author Topic: Upgrading from mysql 4.0 to 4.1 : trouble?  (Read 3469 times)

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
Upgrading from mysql 4.0 to 4.1 : trouble?
« 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?
There is a difference between knowing the path and walking the path.

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

Offline forsakenlad

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,134
  • Gender: Male
  • aka forsakenlad
    • erenyasarkurt on Facebook
    • erenyasarkurt on LinkedIn
    • @erenyasarkurt on Twitter
Re: Upgrading from mysql 4.0 to 4.1 : trouble?
« Reply #1 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 ;)
Eren "forsakenlad" Ya┼čarkurt
SMF Friend & Former Team Member

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
Re: Upgrading from mysql 4.0 to 4.1 : trouble?
« Reply #2 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?
There is a difference between knowing the path and walking the path.

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

Offline H

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,662
  • Gender: Male
Re: Upgrading from mysql 4.0 to 4.1 : trouble?
« Reply #3 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
-H
Former Support Team Lead
                              I recommend:
Namecheap (domains)
Fastmail (e-mail)
Linode (VPS)