MySQL 实现调用外部程序和系统命令

MySQL 实现调用外部程序和系统命令

Refer:

http://www.cnblogs.com/yunsicai/p/4080864.html

1) Download lib_mysqludf_sys
    $ git clone https://github.com/mysqludf/lib_mysqludf_sys.git

2) get mysql plugin dir as LIBDIR:

mysql > show variables like 'plugin_dir';

+--------------+--------------------------+
|variable_name |           value          |
+--------------+--------------------------+
| plugin_dir   |  /usr/lib64/mysql/plugin |
+--------------+--------------------------+

3) Modify Makefile as below:  编译64位的so

LIBDIR=/usr/lib64/mysql/plugin

install:
        gcc -m64 -fPIC -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o $(LIBDIR)/lib_mysqludf_sys.so

4) If need, install:
    $ apt-get install libmysqlclient-dev

5) Compile on the mysql linux server:
    $ sudo make install

    That will generate and copy lib_mysqludf_sys.so into $(LIBDIR)

**********************************************************************************************

或者省去上面的步骤，直接下载：

ftp://pub:[e-mail]/tarball/lib_mysqludf_sys.tar.gz

里面包含了已经编译好的64位 lib_mysqludf_sys.so，只要复制到 plugin_dir 目录下即可。

**********************************************************************************************

6) Install the library 'lib_mysqludf_sys.so' from terminal using following command:
    $ mysql -u root -p??? -h xxx
    mysql> source ./lib_mysqludf_sys.sql