1. 

   eugfri, Member

   hi,

   My client's mydbr based system runs on very old mysql ver 5.6 installed as part of XAMPP package and I need to get it to at least ver mysql 8.X. Hence need your advice on how the best to handle mydbr product schema. I have 2 main schemas - 1) client's data schema 2) mydbr product schema where all my custom mydbr code lives and this code queries and updates data in client's data schema.

   I would like to do things in the safest way and upgrade my 5.6 to 5.7 first, then i will be able to run mysql upgrade checker tool which is only available from ver 5.7 and onwards and it can show me what other potential issues I may run into while trying to move from 5.7 to 8.X.

   I am thinking of the following approach.
   1) full backup of my 5.6 mysql instance
   2) rename 5.6 mysql dir to mysql.old
   3) install 5.7 mysql into my XAMPP home dir and copy my old my.ini from mysql.old (old 5.6 home dir)
   4) restore dbs from backups (client data schema and mydbr product schema)

   My question - will existing mydbr installation initially installed on mysql 5.6 work against mysql upgraded to 5.7 as I described above?
   Also, would mydbr installation setup with mysql 5.7 work "as is" against mysql upgraded from 5.7 to 8.X (mydbr schema backed up in mysql 5.7 and restored into mysql 8.X)?

   I plan to try these upgrade steps in my test environment but would really appreciate some guidance on this.

   Thank you very much!
2. 

   myDBR Team, Key Master

   MySQL 5.6 official support ended a few years ago, so it’s a good idea to update to a newer version.

   The first step is to decide whether you want to upgrade to a newer version of MySQL or switch to MariaDB, a drop-in replacement for MySQL. Notably, XAMPP has already transitioned to using MariaDB.

   Before updating, the most important step is to create a backup of your installation, including settings and databases. Usually, the easiest way to update is by installing the new database server version and running the mysql_upgrade utility.

   Alternatively, you can dump the databases and restore them afterward. If you choose this approach, ensure that you include routines in the database dump.

   --
   myDBR Team
3. 

   eugfri, Member

   Yes, understood. My first step is to get from mysql 5.6 to 5.7. Some of the tables i have are super large (100 mln+ rows) and i did try to use mysql_upgrade in my test environment and it wasn't successful, so I plan to do backup in 5.6 and then restore in 5.7. And yes, i m backing up with the code of course.

   My question is about mydbr schema. If i had mydbr initially installed on mysql 5.6, backed it up and restored into 5.7 - my installation of mydbr should still work without any issues, correct? I.e. mydbr install home directory won't require any updates or anything (assuming db connection parameters will remain exactly the same - host, port, credentials etc).
4. 

   myDBR Team, Key Master

   Yes, myDBR database is just another database and you can load it from the backup. Make sure you use the same credentials when you create the database. This way the permissions to the routines in db level stay the same.

   --
   myDBR Team

Reply

You must log in to post.