When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"

[eatkeylimepie]

My sql logs are not giving me much feedback for what is going wrong here, any suggestions?

[bbunge]

Linux and MySQL versions please...

[SteveGilvarry]

Did you run it with an account with permissions to create tables? Check your readme for distro probably has some instructions to run it as -u root.

[eatkeylimepie]

Yes, I am trying to run it with elevated permissions, this is the command I am using, it prompts for a password and the password is valid.

mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql

I am on Ubuntu 14.04.4.

mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3

Thanks for the help!

[bbunge]

Well, it looks like your command is correct. You may want to try again using these instructions:
https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way

Might be best to reinstall Ubuntu and while you are at it use 16.04 with instructions for ZM here:
https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way

[knight-of-ni]

Googling reveals "can't create table errno: -1" is caused by corrupt sql tables. The corruption is such that you can just drop the table and recreate it, and you can't write over it... catch 22. The simplest approach may be to just apt-get purge mysql, manually go in and delete any leftover datbase files, and reinstall mysql, and create a new zoneminder database.