[Question] What is innodb?

[Espionage724]

I went to svn update NCDB and there were several .sql files changed for something called "innodb" and I was wondering what this was.

[MentaL]

[Espionage724]

Hmm I should have probably search before I posted this. InnoDB is some kind of technology in MySQL that speeds up certain things including how it R/W to the disc.

[Paperz]

ye i tried that update,it failed for me

[codewarrior]

Hey dudes,

InnoDB is another DB engine, that's pluged on mySql. Today, its belong to Oracle corporation, and it's very common to use in on Mysql, if you handle many transactions on the same database and/or table.

You can find more at: InnoDB - Wikipedia, the free encyclopedia

hugz!

[Espionage724]

I tried running that update on 2 of my character dbs. It only ran on one of them for some reason.

[codewarrior]

I tried running that update on 2 of my character DBs. It only ran on one of them for some reason.

There is no reason to it's not run in any table,
BUT,
it's may not run on server without InnoDB support =)

check your my.ini/cnf for skip-innodb or some like that. if you have it,
it's set as, well, to skip InnoDB support... so just comment this entry
(ie, put an # at start of the line) and restart the server.

btw, i recommend you to download the MySQL GUI Tools and run the MySQL Administrator, so you can easily setup
most of MySQL parameters in a very intuitive interface.

hugz!