Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-17-2015, 09:20 AM   #1
LQ Newbie
Registered: Nov 2015
Posts: 3

Rep: Reputation: Disabled
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.

Last edited by gump74; 11-17-2015 at 10:08 AM. Reason: added more detail
Old 11-17-2015, 05:48 PM   #2
Registered: Aug 2002
Posts: 19,399

Rep: Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089Reputation: 3089
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.
Old 11-17-2015, 08:03 PM   #3
LQ Newbie
Registered: Nov 2015
Posts: 3

Original Poster
Rep: Reputation: Disabled
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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Drupal or PHP won't connect to database after database is restarted Skaperen Linux - Software 2 09-23-2011 05:04 PM
NTOP Error Traversing Database for ipnum = - Perhaps database is corrupt? soslinux Linux - Networking 2 03-03-2010 07:28 AM
DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error kaplan71 Linux - Software 3 06-05-2009 01:39 PM
(my)sql: drop database doesn't remove database kpachopoulos Programming 3 09-19-2007 02:32 PM
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 09:20 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:28 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration