This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
building_mariadb_on_freebsd [2017/07/02 02:05] k2patel |
building_mariadb_on_freebsd [2017/07/02 02:10] k2patel |
||
---|---|---|---|
Line 10: | Line 10: | ||
- | Modular configure (usually you need to load plugins with my.cnf) i am using this one. | + | **Modular configure** (usually you need to load plugins with my.cnf) i am using this one. |
<code bash> | <code bash> | ||
Line 17: | Line 17: | ||
OR | OR | ||
- | Build With Plugin | + | **Build With Plugin** |
<code bash> | <code bash> | ||
./configure --with-extra-charsets=all --with-plugin-maria --with-plugin-xtradb --localstatedir=/var/db/mysql | ./configure --with-extra-charsets=all --with-plugin-maria --with-plugin-xtradb --localstatedir=/var/db/mysql | ||
Line 24: | Line 24: | ||
OR | OR | ||
- | Static Build as suggested by MariaDB wiki. | + | **Static Build** as suggested by MariaDB wiki. |
<code bash> | <code bash> | ||
./configure --prefix=/usr/local/mysql --enable-assembler \ | ./configure --prefix=/usr/local/mysql --enable-assembler \ | ||
Line 36: | Line 36: | ||
Now run “make -j4” and “make install” – will install it on system. | Now run “make -j4” and “make install” – will install it on system. | ||
- | rc script | + | ==== rc script ==== |
You can simply use script provided with port version of mysql. | You can simply use script provided with port version of mysql. | ||
Just in case if you dont have it, use below. | Just in case if you dont have it, use below. | ||
- | | /usr/local/etc/rc.d/mysql | + | <code bash /usr/local/etc/rc.d/mysql> |
#!/bin/sh | #!/bin/sh | ||
# | # | ||
Line 116: | Line 117: | ||
run_rc_command "$1" | run_rc_command "$1" | ||
- | Enable and Start | + | </code> |
+ | |||
+ | **Enable and Start** | ||
Final steps…. (remember i am using Modular configure) | Final steps…. (remember i am using Modular configure) | ||
- | | /etc/my.cnf | + | <code bash /etc/my.cnf> |
[mysqld] | [mysqld] | ||
## | ## | ||
Line 183: | Line 186: | ||
#master-connect-retry=60 | #master-connect-retry=60 | ||
#replicate-ignore-db=mysql,test | #replicate-ignore-db=mysql,test | ||
+ | |||
+ | </code> | ||
+ | |||
Enabled it in rc.conf | Enabled it in rc.conf | ||
+ | <code bash> | ||
echo 'mysql_enable="YES"' >> /etc/rc.conf | echo 'mysql_enable="YES"' >> /etc/rc.conf | ||
+ | </code> | ||
+ | |||
Now start it using. | Now start it using. | ||
+ | <code bash> | ||
/usr/local/etc/rc.d/mysql-server start | /usr/local/etc/rc.d/mysql-server start | ||
- | Error | + | </code> |
+ | |||
+ | **Error** | ||
If you get any error related to DB not found (usually get created on first RUN). | If you get any error related to DB not found (usually get created on first RUN). | ||
+ | <code bash> | ||
mysql_install_db --datadir=/usr/local/var | mysql_install_db --datadir=/usr/local/var | ||
- | ENJOY!! Optimized Version of MySQL MariaDB | + | </code> |
+ | |||
+ | **ENJOY!! Optimized Version of MySQL MariaDB** |