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. |
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 |
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. |