Enable and convert MySQL to innodb file per table for Zoneminder

[Camera_Doc]

https://wiki.zoneminder.com/Enable_and_ ... Zoneminder


I have tried to follow this wiki but get an error on the following command

Code: Select all

Verify all InnoDB tables gone

SELECT table_name, table_schema, engine FROM information_schema.tables WHERE engine = 'InnoDB';

Code: Select all

bash: SELECT: command not found

What am I doing wrong?

[bbunge]

What flavor and version of Linux are you running?

Which version of MySQL? If you are running MySQL 5.6 or beyond you do not need to do this as innodb_file_per_table is the default.

[bbunge]

It has been a while since I ran that procedure so I did it again. The message you got is not an error but what should be returned if you did things right.

[m3lab]

https://wiki.zoneminder.com/Enable_and_ ... Zoneminder

What am I doing wrong?

Nothing ...

SELECT is a MySql command so the correct line should be

Code: Select all

mysql SELECT ...

My best,
m.

[Camera_Doc]

I run zoneminder on a Raspberry Pi 2
Uninstalled Zoneminder changed to innodb in my.cnf.
Installed zonminder again.
Zoneminder has not stopped after the change.

Perhaps adding to https://wiki.zoneminder.com/Raspbian



This is what my my.cnf looks like

• [mysqld]
  innodb_file_per_table
  innodb_buffer_pool_size = 512m
  query_cache_type = 1
  innodb_buffer_pool_instances = 1
  
  query_cache_limit = 2M