MySQL Forums
Forum List  »  Microsoft SQL Server

pugin help for innoDB
Posted by: ashley friend
Date: September 07, 2009 05:21PM

i am on windows 2003 sever on a vps and try to instill innodb and stuck on number 2 and i puy on apcial my.in file and does not work

here is the info

# Copy the file ha_innodb.dll to the folder where MySQL looks for plugins, which is generally the lib\plugin sub-folder in the folder where the MySQL server is installed (which is identified by basedir in the my.cnf or my.ini option file). If the lib\plugin folder does not exist, you may create it manually.
# Edit the option file (my.ini) to ignore the builtin InnoDB, and load the InnoDB Plugin and all Information Schema tables implemented in the InnoDB Plugin when the server starts:

ignore_builtin_innodb
plugin-load=innodb=ha_innodb.dll;innodb_trx=ha_innodb.dll;
innodb_locks=ha_innodb.dll;innodb_lock_waits=ha_innodb.dll;
innodb_cmp=ha_innodb.dll;innodb_cmp_reset=ha_innodb.dll;
innodb_cmpmem=ha_innodb.dll;innodb_cmpmem_reset=ha_innodb.dll

Note that all plugins for plugin-load should be on the same line in the option file. Alternatively, you can use the equivalent options on the MySQL command line:

mysqld --ignore-builtin-innodb --plugin-load=innodb=ha_innodb.dll;
innodb_trx=ha_innodb.dll;innodb_locks=ha_innodb.dll;
innodb_lock_waits=ha_innodb.dll;innodb_cmp=ha_innodb.dll;
innodb_cmp_reset=ha_innodb.dll;innodb_cmpmem=ha_innodb.dll;
innodb_cmpmem_reset=ha_innodb.dll

Options: Reply• Quote


Subject
Written By
Posted
pugin help for innoDB
September 07, 2009 05:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.