Upgrading MySQL Server 5.1 Directly To MySQL Server 8.0 On Centos 6 With MySQLDump
00:02:20 Checking the MySQL version in some test sites.
00:06:00 Running the database backup script.
00:07:05 Installing Percona Toolkit to get the user logins.
00:09:15 Adding the MySQL 8.0 repo to the Centos 6
00:12:10 Starting the new MySQL service.
00:12:55 Changing the temporary root password.
00:17:15 Loading the backup into the new database.
00:19:10 Adding back the passwords.
00:20:40 Checking that the sites are working again.
In this video I am showing how to upgrade some databases from MySQL 5.1 to MySQL 8.0 and I ended up doing this video because of how I had to migrate some of my old databases, to a newer major version of MySQL. The process is not that difficult when it comes to getting the data across, but the problems then start to arise for when it comes to migrating the passwords.
I have put the commands that I used up on my website at:
https://www.macpczone.co.uk/content/upgrading-mysql-server-51-directly-mysql-server-80-centos-6-mysqldump
YouTube does not like the redirection character and treats you as if you are trying to do some XSS.
centos 7
