Joomla!-开源天空

2008-10-12
首页 专栏热点 LAMP开发与web 2.0 如何卸载 mysql PLUGIN


如何卸载 mysql PLUGIN

E-mail
UNINSTALL PLUGIN Syntax
UNINSTALL PLUGIN plugin_name

以上的语法就删除了已安装的plugin, You cannot uninstall a plugin if any table that uses it is open.

plugin_name 必须是 mysql.plugin table中的名称. 服务器执行卸载过程,并删除mysql.plugin表的行,这样当服务器重启的时候,不会再执行已卸载的plugin,这个语句并不删除共享库文件。

应该具有delete 的权限,才能执行uninstall plugin .

Plugin removal has implications for the use of associated tables. For example, if a full-text parser plugin is associated with a FULLTEXT index on the table, uninstalling the plugin makes the table unusable. Any attempt to access the table results in an error. The table cannot even be opened, so you cannot drop an index for which the plugin is used. This means that uninstalling a plugin is something to do with care unless you do not care about the table contents. If you are uninstalling a plugin with no intention of reinstalling it later and you care about the table contents, you should dump the table with mysqldump and remove the WITH PARSER clause from the dumped CREATE TABLE statement so that you can reload the table later. If you do not care about the table, DROP TABLE can be used even if any plugins associated with the table are missing.



收藏此文章:
Digg! Reddit! Del.icio.us! JoomlaVote! Google! Live! Facebook! StumbleUpon! Yahoo! Free social bookmarking plugins and extensions for Joomla! websites!

发表您的文章评论

您的姓名 (昵称)
标题:
评分: 很差一般较好很好
评论:
验证码:
请输入验证码