1.26.3 installation mysql query - Solved

[codabiz]

After a few hiccups, I successfully made a clean fresh install of Zoneminder 1.26.3 on Ubuntu Server 12.04LTS (32 bit).

The biggest hiccup I had was trying to load initial SQL table into mysql 'zm' database.
Tried:
mysql -u root -p zm < db/zm_create.sql
It didn't work!

Succeeded with:
mysql -u root -p zm < /tmp/ZoneMinder-1.26.3/db/zm_create.sql

I am a bit of a newbie, did I miss a step or miss a trick?

Solved. I had downloaded zoneminder to /temp directory

[2Psycho]

Probably the script you want to load to update the database is part of the Zoneminder build

Code: Select all

zmupdate.pl --user=root --pass=MYSQLROOTPASSWORD

You can find it in the folder
/usr/local/bin

Otherwise type locate zmupdate.pl