How To Upgrade Mysql In Ubuntu

Please consider supporting Anna Filina’s Ukrainian relatives https://afilina.com/donate/ua-supplies
Other ways to support the people of Ukraine https://supportukrainenow.org
——
. Answering the question of how to upgrade MYSQL on Ubuntu which was asked by Steve Baker.
In this questions and answers video I demonstrate how to an older version of MYSQL on Ubuntu and then how to create a database with a table. I then show where the physical MYSQL files are stored on the Ubunutu server. Then I demonstrate how to backup the database using mysqldump. Once the data is backed up I remove the old version of MYSQL (5.6) and install MYSQL 5.7.
Once the MYSQL has been upgrade I then import the backed up data into the new version of MYSQL

– Learn more about the PHP IDE I am using with the instant PHPStorm stater book
http://amzn.to/2sqjv7W

This was filmed using
– Go Pro Hero 4 Silver
http://amzn.to/2tR4Rec

– Rode Pro Caster microphone
http://amzn.to/2sH2WJ1

– Adobe Premiere Pro CC
http://amzn.to/2tMn6ke

==== GET EARLY ACCESS TO FUTURE VIDEOS & TUTORIALS ====

Patron: http://bit.ly/2hmVKwX

======== RECOMMENDED PROGRAMMING RESOURCES ========

Manning programming books and courses: http://bit.ly/2BIrExp

Python Crash Course: http://amzn.to/2lRvw4l
PHP Web Services: APIs for the Modern Web: http://amzn.to/2tqiyOl
Responsive Web Design with HTML5 and CSS3: http://amzn.to/2tSo6nH.

======== MY PROGRAMMING COURSES ========

Docker in Motion: http://bit.ly/2vvz2sA
Skillshare courses: http://skl.sh/2gI33M5
Udemy courses: http://bit.ly/2iGhvIE

======== WEB HOSTING DEALS ========

Cloudways: http://bit.ly/2CKb79b = 20% off first 6 months
Digital Ocean: https://m.do.co/c/9d4641c62263 = $10 off
Linode: http://bit.ly/2CmoNq3

======== SUBSCRIBE TO THE NEWSLETTER ========

Join the Newsletter: http://bit.ly/2fPlG3v

======== FOLLOW ME ========

Blog: http://peterfisher.me.uk
Facebook: http://facebook.com/howtocodewell/
Instagram: http://instagram.com/howtocodewell/
Twitter: http://twitter.com/howToCodeWell
Pintrest: http://pinterest.co.uk/howtocodewell/
Twitch: http://twitch.tv/howtocodewell

======== MY TALKS ========

How to put your Docker image on a diet: http://bit.ly/2y5KMly

======== SUPPORT THE CHANNEL ========

Become a Patron: http://bit.ly/2hmVKwX
Donate: https://www.paypal.me/howToCodeWell
Help translate the videos: http://bit.ly/2iEyxXB

======== VIDEO SETUP ========

Nikon D5300 Camera: http://amzn.to/2u5jreD
Logitech HD Pro Webcam C920 http://amzn.to/2C5NNVJ
CRAPHY Photography Studio Lights: http://amzn.to/2BThzOc
Rode Procaster Microphone: http://amzn.to/2sH2WJ1
Rode VideoMic Pro: http://amzn.to/2vmNF0D
Zoom H4NPro: http://amzn.to/2kZrrvo