How do I determine the default MySQL Storage Engine?
- Open MAMP PRO
- Start the servers
- Open Terminal.app (/Applications/Utilities)
- Enter the following line into the terminal and hit enter:
cd /Applications/MAMP/Library/bin - Enter the following line into the terminal and hit enter:
./mysql --host=localhost -u root -proot - Enter the following line into the MySQL prompt and hit enter:
USE information_schema; - Enter the following line into the MySQL prompt and hit enter:
SELECT * FROM engines; - A table with the Storage Engines of MySQL will show up. Inside the Support column the Default Storage Engine has the value DEFAULT.
- Enter the following line into the MySQL prompt and hit enter:
exit;