Welcome to Geeklog, Anonymous Thursday, May 23 2024 @ 11:11 pm EDT

Geeklog Forums

BD type MyISAM to Innodb


Status: offline

koalasoft

Forum User
Full Member
Registered: 03/09/05
Posts: 242
Location:Mexico
My Base de Datos Geeeklog is of type (MyISAM), but I require that these are type (Innodb).

It exists is some form to be able to do this? to turn of MyISAM type to Innodb for my Geeklog system?

Grettings !! Mr. Green
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
InnoDB tables are an option when you install Geeklog. To change an existing installation, use the script located in public_html/admin/install/toinnodb.php

Of course, you should know what you're doing when you switch to InnoDB tables ...

bye, Dirk
 Quote

Status: offline

koalasoft

Forum User
Full Member
Registered: 03/09/05
Posts: 242
Location:Mexico
I would like to know as it is the difference between these two types of tables and in which would help me or advantages to use MyISAM or in its Innods case in my Geeklog.

Grettings !! Mr. Green
**Cuando el Alumno esta listo, el Maestro Aparece **
::Geeklog support in Spanish::
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
To put it bluntly: If you have to ask, you shouldn't use InnoDB.

It's really only useful for big sites with a lot of traffic. The downside is that it makes it harder to get a consistent database backup (in fact InnoDB, now owned by Oracle, are selling a backup utility just for that reason).

bye, Dirk
 Quote

All times are EDT. The time is now 11:11 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content