ZendDBi

General discussion on Zend Server for IBM System i

ZendDBi

Postby silv7133 on Thu Apr 27, 2017 10:21 am

Hi all

did anyone already migrate from MySql 5.1 to mariaDB 10.1?
If yes what steps are really needed?

I tried to search in mariaDB forum, but there most say the upgrade should be done in 2 steps. First to mariaDB 5.5 and then to mariaDB 10. But as we don't have any mariaDB 5.5 this is of course not possible.

regards and thank
Silvan
silv7133
 
Posts: 4
Joined: Fri Feb 28, 2014 5:29 pm

Re: ZendDBi

Postby zvika on Thu May 04, 2017 7:46 am

Hello Silvan
There is plenty of information on the web, basically its MySQL 5.1 schema upgrade to MySQL 5.7.
You can test the SQL which creates the tables first, and try your application tests on it, before migrating real world data between old and new DB engines.

If you have more business questions and concerns, please open a support ticket so we can answer with more focus.

Some links:
https://mariadb.com/kb/en/mariadb/direc ... ia-db-101/
https://dba.stackexchange.com/questions ... 5-7-schema
https://dev.mysql.com/doc/refman/5.7/en ... ation.html
Zvika Dror
Zend Support Team
User avatar
zvika
Zend Global Support
 
Posts: 984
Joined: Sun Dec 14, 2008 9:48 am


Return to Zend Server for IBM i

Who is online

Users browsing this forum: No registered users and 3 guests