Differences

This shows you the differences between two versions of the page.

--- building_mariadb_on_freebsd [2017/07/02 02:02] – created k2patel
+++ building_mariadb_on_freebsd [2020/08/10 02:35] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-Build / Compile MariaDB on FreeBSD
+====== Build / Compile MariaDB on FreeBSD ======
-Getting Source
-get source from MariaDB
+==== Getting Source ====
+get source from [[http://www.mariadb.org/|MariaDB]]\\
 extract to /usr/local/src/mariadb
-Configure
+==== Configure ====
-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>
 ./configure --with-extra-charsets=all --localstatedir=/var/db/mysql
+</code>
 OR
-Build With Plugin
+**Build With Plugin**
+<code bash>
 ./configure --with-extra-charsets=all  --with-plugin-maria --with-plugin-xtradb --localstatedir=/var/db/mysql
-OR
+</code>
-Static Build as suggested by MariaDB wiki.
+OR
+**Static Build** as suggested by MariaDB wiki.
+<code bash>
 ./configure --prefix=/usr/local/mysql --enable-assembler \
 --with-extra-charsets=all  --enable-thread-safe-client  --with-big-tables \
@@ Line 26: / Line 33: @@
 --with-mysqld-ldflags=-all-static  --with-client-ldflags=-all-static \
 --with-zlib-dir=bundled --enable-local-infile
+</code>
 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.
 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
 #
@@ Line 108: / Line 117: @@
 run_rc_command "$1"
-Enable and Start
+</code>
+**Enable and Start**
 Final steps…. (remember i am using Modular configure)
-| /etc/my.cnf
+<code bash /etc/my.cnf>
 [mysqld]
 ##
@@ Line 175: / Line 186: @@
 #master-connect-retry=60
 #replicate-ignore-db=mysql,test
+</code>
 Enabled it in rc.conf
+<code bash>
 echo 'mysql_enable="YES"' >> /etc/rc.conf
+</code>
 Now start it using.
+<code bash>
 /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).
+<code bash>
 mysql_install_db --datadir=/usr/local/var
-ENJOY!! Optimized Version of MySQL MariaDB
+</code>
+**ENJOY!! Optimized Version of MySQL MariaDB**