LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MotionEye database to multiple database files (https://www.linuxquestions.org/questions/linux-software-2/motioneye-database-to-multiple-database-files-4175559104/)

gump74 11-17-2015 08:20 AM

MotionEye database to multiple database files
 
Greetings all,
OK I'm not sure how to start this question but here are the basics. I have a raspberry pi with MotionEye that records to files. MotionEye is the front end for Motion. Motion can instead of save video files separately it can save videos to a database and it seems they prefer mysql. Can I configure Motion to use a database without screwing up the MotionEye? I have a lot of experience programming databases in MS Access but I have not used mysql. On top of that I would like to have mysql control several database files instead of having several mysql servers. Can that be done? I know it can be done in Access so I assume it can be done with mysql. I want 3 databases 1 on the pi 2 on my laptop and 3 on my google drive shared out, and I want the one mysql server to replicate between all three. Including if I delete a record on one the records in the other databases should also be deleted. Can that be done? In Access its called full replication. Is there a video player for motion that can play the videos from the database file/s? Is there one that does not need to be installed? I cannot install programs at work. Is there a VLC pluging that can do this? Will it allow me to delete records? Can I run VLC with out installing it? I don't want the player to connect to the sql server I need to play from the database file. Since the videos would be saved on the google drive and my ISP gives me a private address I can't use DDNS. Is there a way to make the database open like a file structure? Like in windows I can click on a zip file and explore it just like a directory.

I know this seems a bit complex but someone must have gone through this before or at least thought about it.

All of you comments and thoughts are welcome. And thank you for your time.

michaelk 11-17-2015 04:48 PM

Per the documentation motion does not save video files (binary) in the database. Not all that familiar with motion configuration but I would guess adding database support will not mess up anything. If in doubt backup any configuration file.

http://lavrsen.dk/foswiki/bin/view/M...sing_Databases

gump74 11-17-2015 07:03 PM

Well, ok then. I had thought that the binary of the video file was stored in the db but from the link it clearly only stores the file name etc. So, I guess the rest of the questions are moot. Thanks for the info.


All times are GMT -5. The time now is 07:59 PM.