forked from outis/lib_mysqludf_str
-
Notifications
You must be signed in to change notification settings - Fork 10
/
Copy pathREADME.win_x64.txt
90 lines (63 loc) · 3.72 KB
/
README.win_x64.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
This is a build of version 0.5 of lib_mysqludf_str for 64-bit MySQL 5.1+ and
Windows XP SP3 or later. It is licensed under the terms of the LGPL
version 2.1 or later, the exact text of which is located in COPYING.
IMPORTANT NOTE: If you are running 32-bit MySQL, then you need the 32-bit version
of lib_mysqludf_str, not the 64-bit version.
All source code for this project is downloadable from GitHub:
https://github.com/mysqludf/lib_mysqludf_str/
INSTALLATION
================================================================================
To install the lib_mysqludf_str UDFs:
1. Make sure that you are running 64-bit Windows and that you have installed
the 64-bit build of MySQL 5.1 or later.
Note: The lib_mysqludf_str.dll binary has only been tested with MySQL version
5.6, but should work with MySQL 5.5, 5.1 and 5.0 as well. It is, however,
incompatible with MySQL 3.23/4.0/4.1.
2. Look for a file named msvcr110.dll in your System32 folder. If this file is
not present, then install the latest Visual C++ Redistributable for Visual Studio 2012
vcredist_x64.exe:
http://www.microsoft.com/en-us/download/details.aspx?id=30679
3. Copy lib_mysqludf_str.dll to the MySQL installation's lib\plugin folder.
With a default installation, this is C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\
Note: You do NOT need to re-start MySQL after copying lib_mysqludf_str.dll
into the plugin directory.
4. As root, source installdb.win.sql or simply paste the contents into the CLI client.
5. Test the setup by executing:
SELECT lib_mysqludf_str_info() FROM DUAL;
The result should be:
+------------------------------+
| lib_mysqludf_str_info() |
+------------------------------+
| lib_mysqludf_str version 0.5 |
+------------------------------+
TROUBLESHOOTING
================================================================================
* ERROR 1126 (HY000): Can't open shared library 'lib_mysqludf_str' (errno: 0 )
This either means that the Visual C++ Redistributable for Visual Studio 2012
is not installed or that MySQL could not find lib_mysqludf_str.dll in the
plugin directory.
Look for a file named msvcr110.dll in your System32 folder. If this file is
not present, then install the latest Visual C++ Redistributable for Visual Studio 2012
vcredist_x64.exe.
Verify that lib_mysqludf_str.dll was copied into the plugin directory by
executing:
SHOW VARIABLES LIKE 'plugin_dir';
The result should be:
+---------------+-----------------------------------------------------+
| Variable_name | Value |
+---------------+-----------------------------------------------------+
| plugin_dir | C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\ |
+---------------+-----------------------------------------------------+
If it's not, then copy lib_mysqludf_str.dll to the listed directory.
* ERROR 1126 (HY000): Can't open shared library 'lib_mysqludf_str.dll' (errno: 193)
This error can happen when you try to use the 64-bit version of lib_mysqludf_str
with a 32-bit MySQL server. Either use the 32-bit version of lib_mysqludf_str
or install 64-bit MySQL.
* ERROR 1127 (HY000): Can't find symbol in library
This means that MySQL was able to find lib_mysqludf_str.dll, but for some
reason, it could not "see" the UDF in the DLL module.
If you are typing the CREATE FUNCTION statements manually, make sure that
you have typed the UDF name exactly as listed in installdb.win.sql. For example,
instead of "STR_XOR", you must type "str_xor" (all lowercase).
If you encounter any other problem, please feel free to contact me at: