Thank you for this. Really helped me pull an old WP website out of the stone age. Your humor also helped me cope with the needless frustration involved.
How ridiculous in 2019 there is no wizard upgrade process for MySQL upgrades. What happens if you have 100+ databases running on your server? You have to backup and restore each one? Poor form on MySQL's behalf.
Hey man, I just have you say you are my hero right now. I was reading through so much documentation only to find myself stumped after every article was referencing multiple versions and features not necessarily present in my scenario. Thank you for taking the time to make and share this!
I followed this today (2024). I installed My SQL Workbench 6.3 instead of 8.0 to be compatible with MySQL 5.1. I also made the mistake of doing a full MySQL export using SQL Administrator. When it came to importing, It was giving me access denied trying to import the information schema. I used Notepad ++ to delete this part of the data from the SQL backup/Export and imported it again successfully. I'm now up to 5.5, and will be doing the 5.6/5.7 upgrades over the next few days.
Great video. I'm in the same boat; we have a wordpress server running MySQL 5.1 and I want to get it to at least 5.6. Did you have to re-create the word press database account again or did that import from the backup automatically? Any other post-upgrade wordpress-related-tasks after the ugprade? Thanks!
How do I stich now my MySql version to the new one because with mysql -V always display this : mysql Ver 14.14 Distrib 5.1.73, for Win64 (unknown) despite 5.6 is installed. And with Mysql Workbench I cannot connect with root account (acces is always denied). My aim is to migrate my Wordpress database from 5.1 to 5.6. I already had 5.5 installed and I followed your video to installed 5.6. Thanks for your help. :-)
I need to migrate a WAMP Server with MySQL 5.6.17 on Windows Server 2008 R2 to MySQL 5.7.28 (or current) on Windows Server 2019, any suggestions? I typically use phpMyAdmin to work with the database, and have done back-ups that way, but am running into issues with restoring tables with over 100k records. Realistic?
The MySQL documentation suggests doing step upgrades: 5.1 to 5.5, then 5.6 then 5.7 etc. I believe there is some database compatibility upgrades that need to happen, that's why 5.1 to 5.7 is not recommended.
Thank you for this. Really helped me pull an old WP website out of the stone age. Your humor also helped me cope with the needless frustration involved.
I also found the documentation very mind boggling. This was very helpful, a godsend
How ridiculous in 2019 there is no wizard upgrade process for MySQL upgrades. What happens if you have 100+ databases running on your server? You have to backup and restore each one? Poor form on MySQL's behalf.
I'm getting ready to start this upgrade. Did you at first uninstall 5.1 and any installer then install 5.5?
Hey man, I just have you say you are my hero right now. I was reading through so much documentation only to find myself stumped after every article was referencing multiple versions and features not necessarily present in my scenario. Thank you for taking the time to make and share this!
I followed this today (2024). I installed My SQL Workbench 6.3 instead of 8.0 to be compatible with MySQL 5.1. I also made the mistake of doing a full MySQL export using SQL Administrator. When it came to importing, It was giving me access denied trying to import the information schema. I used Notepad ++ to delete this part of the data from the SQL backup/Export and imported it again successfully. I'm now up to 5.5, and will be doing the 5.6/5.7 upgrades over the next few days.
Thank you sir, this was an excellent help, mysql upgrade work completed thanks to you. Liked a lot.
Great video. I'm in the same boat; we have a wordpress server running MySQL 5.1 and I want to get it to at least 5.6. Did you have to re-create the word press database account again or did that import from the backup automatically? Any other post-upgrade wordpress-related-tasks after the ugprade? Thanks!
How do I stich now my MySql version to the new one because with mysql -V always display this : mysql Ver 14.14 Distrib 5.1.73, for Win64 (unknown) despite 5.6 is installed. And with Mysql Workbench I cannot connect with root account (acces is always denied). My aim is to migrate my Wordpress database from 5.1 to 5.6. I already had 5.5 installed and I followed your video to installed 5.6. Thanks for your help. :-)
is that possible that we backup the database, uninstall 5.1 and install any other update version like 5.7 or 8.0?
I need to migrate a WAMP Server with MySQL 5.6.17 on Windows Server 2008 R2 to MySQL 5.7.28 (or current) on Windows Server 2019, any suggestions? I typically use phpMyAdmin to work with the database, and have done back-ups that way, but am running into issues with restoring tables with over 100k records. Realistic?
Love the commentary and SOH :-) and thank you. I was trying to find from 5.1 to 5.7 or something..
Now it's 2021 why are we still fat finger in commands?
Yup... I just go to fast :(
I don't have mysql administrator
Use MySQL Workbench and do the Export option. That's what I did. Then use Import to load the database.
@@billkoerner6751 Thanks
is that possible that we backup the database, uninstall 5.1 and install any other update version like 5.7 or 8.0?
The MySQL documentation suggests doing step upgrades: 5.1 to 5.5, then 5.6 then 5.7 etc. I believe there is some database compatibility upgrades that need to happen, that's why 5.1 to 5.7 is not recommended.