List:General Discussion« Previous MessageNext Message »
From:Siegfried Heintze Date:September 4 2005 7:37pm
Subject:How to migrate from V4.0.23 to V5?
View as plain text  
My questions are probably addressed in the MySQL documentation somewhere.
I've been reading the documentation on backup but I'm not sure if that is
the right tool for this situation.  Perhaps there is a better place to be
reading?

Apparently my 4.0.23 database on my notebook is corrupted as one large table
appears to be empty. Fortunately, I had used zip to create a copy of the
mysql/data directory on CD. I have a new V5 installation on my new desktop
computer.

I really don't care about having a copy of the data on my notebook anymore.
What should I do?

Should I restore the data directory to my notebook and create a backup
(using the mysqldump) and then restore the backup on v5?

Or should I just restore the V4.0.23 mysql/data directory that is on the CD
directly to the v5 directory? Are the formats of the data files compatible?

Or is there is there a special utility for copying from one mysql instance
to another?

I created all the tables my self using MySQL CC and I never did anything
special like incorporate innodb (sp?).

Thanks,
Siegfried

Thread
Trouble with revoke allScott Haneda2 Sep
  • Re: Trouble with revoke allGleb Paharenko2 Sep
    • Re: Trouble with revoke allScott Haneda2 Sep
      • Re: Trouble with revoke allMichael Stassen2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
          • Re: Trouble with revoke allMichael Stassen3 Sep
            • Re: Trouble with revoke allScott Haneda3 Sep
              • Multiple query execution (probably OT)Alvaro Cobo3 Sep
                • Re: Multiple query execution (probably OT)Gleb Paharenko3 Sep
                • How to migrate from V4.0.23 to V5?Siegfried Heintze4 Sep
                  • Re: How to migrate from V4.0.23 to V5?Gleb Paharenko5 Sep
      • Re: Trouble with revoke allGleb Paharenko2 Sep
        • Re: Trouble with revoke allScott Haneda3 Sep
    • 2 query questionsYL2 Sep
      • Re: 2 query questionsJason Pyeron2 Sep
      • Re: 2 query questionsSGreen2 Sep
        • string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep
        • Re: string->array question. ( 2 query questions)YL3 Sep
          • Re: string->array question. ( 2 query questions)Peter Brawley3 Sep