Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was going through upgrade process of mysql server. It is mentioned that to upgrade from 4.1 to 5.5 we need to upgrade step by step like first to 5.0,5.1 ...5.4 and then 5.5.

I have some questions :

  • What if we directly upgrade from 4.1 to 5.5. What might get effected? functionality or problem related to upgrading
  • Chances to loose data ? Even though I'll take backup using 'mysqldump --all-data-base' option.
  • Lets say, I have two database. I'll take only two database backup. I'll install latest version of mysql 5.7 and load two database back. What are chances to loose data or get corrupted ?

I'm curious to know this. If anybody tried? Because I need to do upgrade in live server.

Is there any step by step document which tells exact steps to upgrade from 4.1 to 5.5 in linux server

share|improve this question
    
I'd do what the documentation says and do it in stages. How big is the database? –  Phil May 27 at 13:20
    
I have two database..both database dump will come around 10MB –  stefun May 27 at 13:31
    
Your datasets are small, so unless the database itself is very complex you could always just dump the schemas and data from 4.1 and import to 5.5. I've done this a few times. –  dartonw May 27 at 19:03
    
Also, you aren't likely to encounter any loss of functionality. Just make sure that every value in my.cnf on 5.5 is carefully tested. IIRC, it was easier to run 5.5 close to the defaults. Just out of curiosity, why 5.5 instead of 5.7? Distro packaging? –  dartonw May 27 at 19:10
    
Actually I need above 5.0 to run procedure which was not supporting in 4.1.anyway I'm trying to install 5.7 only. Thank you for your suggestions –  stefun May 27 at 19:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.