MySQLからMariaDBへ

CONTENTS

Lastmodified　2023-06-05 (月) 10:25:15

MySQLからMariaDBへ†

https://gihyo.jp/admin/clip/01/fdt/201305/30

https://www.unixmen.com/migrate-from-mysql-to-mariadb-in-freebsd/

MySQL > MariaDB 移行を開始する前にデータベースをバックアップしてください。†

次のコマンドを使用して MySQL デーモンを停止します。†

# service mysql-server stop

Update ports collection†

Check which version of MySQL you have:†

# pkg_version -v | grep mysql
mysql-client-5.5.17                 =   up-to-date with port
mysql-server-5.5.17                 =   up-to-date with port
...

We need to uninstall MySQL Server & Client ports†

# cd /usr/ports/databases/mysql55-server/
# make deinstall clean
# cd /usr/ports/databases/mysql55-client/
# make deinstall clean

Installing MariaDB Server, MariaDB Client and MariaDB Scripts:†

# cd /usr/ports/databases/mariadb-server
# make install clean

You should check following options:†

[X] SSL        Activate SSL support (yassl)
[X] ARIADB     Aria storage engine
[X] ARCHIVE    Archive storage plugin
[X] BLACKHOLE  Blackhole storage engine
[X] SPHINX     SE client for Sphinx search daemon
[X] FEDX       FederatedX storage engine (Federated replacement)
[X] XTRADB     XtraDB (InnoDB replacement) engine
[X] PBXT       MVCC-based transactional engine

MariaDB Client will be installed automatically. You should now check following options:

[X] THREADSAFE  Build thread-safe client
[X] SSL         Activate SSL support (yassl)

Installing MariaDB Scripts:†

# cd /usr/ports/databases/mariadb-scripts/
# make install clean

Check if all ports installed OK:†

# pkg_version -v | grep maria 
mariadb-client-5.2.9                =   up-to-date with port
mariadb-scripts-5.2.9               =   up-to-date with port
mariadb-server-5.2.9                =   up-to-date with port

8) Starting MariaDB Server:†

# service mysql-server start

9) If you didn’t have a MySQL server before, you should create password for root user after MariaDB installation:†

# mysqladmin -u root password YOURSECUREPASSWORD

10) Some tips if you get errors like this:†

/libexec/ld-elf.so.1: Shared object "libmysqlclient.so.18" not found, required by "postfix"

#1286 - Unknown table engine 'InnoDB'

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /usr/home/usadentists/usadentists.com/htdocs/includes/lock.inc).

apache-2.2.17_1 cannot install: unknown MySQL version: 52.

Tip 1: If your have Postfix or/and Dovecot with MySQL support, you should re-install them.

Tip 2: If you get message with unknown MySQL version when installing ports, you should edit /etc/make.conf and add line:

MYSQL52_LIBVER=16 Tip 3: If you using Drupal 7, Postfixadmin or other software which requires InnoDB tables or Sphinx Search Engine, you should activate following plugins:

# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4656
Server version: 5.2.9-MariaDB-log Source distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> INSTALL PLUGIN innodb SONAME 'ha_xtradb.so';
Query OK, 0 rows affected (0.11 sec)

MariaDB [(none)]> show engines;

1. ------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+

   Engine

   Support

   Comment

   Transactions

   XA

   Savepoints

2. ------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+

   MyISAM	DEFAULT	Default engine as of MySQL 3.23 with great performance	NO	NO	NO
   InnoDB	YES	XtraDB engine based on InnoDB plugin. Supports transactions, row-level locking, and foreign keys	YES	YES	YES
   PBXT	YES	High performance, multi-versioning transactional engine	YES	YES	NO
   MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
   CSV	YES	CSV storage engine	NO	NO	NO
   SPHINX	YES	Sphinx storage engine 0.9.9	NO	NO	NO
   Aria	YES	Crash-safe tables with MyISAM heritage	NO	NO	NO
   MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO

3. ------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+ 8 rows in set (0.00 sec)

MariaDB [(none)]> exit;

Total access 72：本日 2：昨日 0

備忘録

Base System:FreeBSD

1. FreeBSD 6.2Rのインストール
   1. portupgrade のインストール
   2. ports collection の更新
   3. sudo のインストール
   4. portaudit のインストール
   5. 時刻同期
   6. screen
2. Tips
   1. portsのインストールオプションの解除・確認・設定
   2. 起動メニュー待ち時間
   3. コンテンツの一括凍結

edit

http://piano2nd.smb.net/webalizer/

https://piano2nd.smb.net/PukiWiki/

https://www.smb.net/PukiWiki/

最新の60件

edit

2023-06-05 (月) 10:25:15