Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-27, 23:10:07

Author Topic: how to upgrade sql from 5.5 yo 5.6  (Read 3439 times)

0 Members and 1 Guest are viewing this topic.

Offline cmdman

  • Senior Member
  • *
  • Posts: 298
  • Karma: +1/-0
    • View Profile
how to upgrade sql from 5.5 yo 5.6
« on: 2015-07-08, 09:06:45 »
how to upgrade mysql from 5.5 to 5.6 in kloxo mr 7

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: how to upgrade sql from 5.5 yo 5.6
« Reply #1 on: 2015-07-08, 09:52:24 »
Kloxo-MR 7.0 using MariaDB 10.x instead MySQL 5.5/5.6.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 298
  • Karma: +1/-0
    • View Profile
Re: how to upgrade sql from 5.5 yo 5.6
« Reply #2 on: 2015-07-08, 13:08:47 »
i moved a user from cpanel to kloxomr but user need mysql 5.6 as its compatible with his system as he need all tables in innodb instead of myisam

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: how to upgrade sql from 5.5 yo 5.6
« Reply #3 on: 2015-07-08, 14:06:41 »
MariaDB is backward compatible for MySQL. No reason to back to use MySQL 5.5/5.6 instead MariaDB.

MyISAM, InnoDB, Aria and TokuDB are storage-engine where only MyISAM and InnoDB exists in MySQL 5.5/5.6. Use 'sh /script/mysql-convert --engine=innodb' to convert all tables to InnoDB.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo

Page created in 0.029 seconds with 18 queries.

web stats analysis