User Tools

Site Tools


building_mariadb_on_freebsd

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
building_mariadb_on_freebsd [2017/07/02 02:05]
k2patel
building_mariadb_on_freebsd [2020/08/10 02:35] (current)
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**
building_mariadb_on_freebsd.1498961124.txt.gz · Last modified: 2020/08/10 02:28 (external edit)