Page 1 of 1

1.26.3 installation mysql query - Solved

Posted: Mon Sep 16, 2013 7:24 pm
by 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

Re: 1.26.3 installation mysql query

Posted: Tue Sep 17, 2013 5:45 pm
by 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 :D