MacportsのMySQLのデフォルトエンジンの設定変更と再起動する方法
デフォルトエンジンをMyISAM → InnoDBに設定し反映する為のメモ。(ver. 5.0.80-standard)
/opt/local/etc/mysql5/my.cnfの[mysqld]以下に、"default-strage-engine=INNODB"を追加
[mysqld] default-storage-engine=INNODB
sudo launchctl stop org.macports.mysql5 sudo launchctl start org.macports.mysql5
接続とデフォルトのエンジン確認
mysql5 -u root -p mysql> show engines; +------------+----------+----------------------------------------------------------------+ | Engine | Support | Comment | +------------+----------+----------------------------------------------------------------+ | MyISAM | YES | Default engine as of MySQL 3.23 with great performance | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | | BerkeleyDB | NO | Supports transactions and page-level locking | | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | | EXAMPLE | NO | Example storage engine | | ARCHIVE | NO | Archive storage engine | | CSV | NO | CSV storage engine | | ndbcluster | NO | Clustered, fault-tolerant, memory-based tables | | FEDERATED | DISABLED | Federated MySQL storage engine | | MRG_MYISAM | YES | Collection of identical MyISAM tables | | ISAM | NO | Obsolete storage engine | +------------+----------+----------------------------------------------------------------+ 12 rows in set (0.00 sec)
そして上手くいったところ、CREATE TABLE文の書いてあるSQLファイル実行時に外部キーを参照しているテーブルを先に書いていてエラーになってたorz
凡ミスすぎてすごく悲しい><
ERROR 1005 (HY000) at line 40: Can't create table './fuga/hoge.frm' (errno: 150)
参考リンク