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. 2021-03-03, 19:22:41

Author Topic: MariaDB engine change to InnoDB  (Read 1538 times)

0 Members and 2 Guests are viewing this topic.

Offline tochits

  • Junior Member
  • *
  • Posts: 39
  • Karma: +0/-0
    • View Profile
MariaDB engine change to InnoDB
« on: 2017-05-30, 05:04:56 »
Can I change the engine to innodb for only a client/database or does converting mean all databases will use innodb?

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MariaDB engine change to InnoDB
« Reply #1 on: 2017-05-30, 07:00:23 »
Better change all database to innodb. You can use 'sh /script/mysql-convert' for this purpose.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline klisa

  • Junior Member
  • *
  • Posts: 44
  • Karma: +0/-0
    • View Profile
Re: MariaDB engine change to InnoDB
« Reply #2 on: 2021-02-10, 07:38:16 »
with this 'sh /script/mysql-convert', all databases convert to InnoDB?

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: MariaDB engine change to InnoDB
« Reply #3 on: 2021-03-02, 16:40:01 »
Use and change:

sh /script/mysql-convert --engine=MyISAM
sh /script/mysql-convert --engine=InnoDB

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.044 seconds with 23 queries.

web stats analysis