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

  • I'd do what the documentation says and do it in stages. How big is the database? – Philᵀᴹ May 27 '14 at 13:20
  • I have two database..both database dump will come around 10MB – stefun May 27 '14 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 '14 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 '14 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 '14 at 19:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.