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. 2023-06-02, 21:33:50
« previous next »
Pages: [1]   Go Down

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

0 Members and 1 Guest 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?
Logged

Offline 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.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline klisa

  • Junior Member
  • *
  • Posts: 45
  • 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?
Logged

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
Logged
Pages: [1]   Go Up
« previous next »
 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine

Page created in 0.075 seconds with 18 queries.

web stats analysis