LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 11-17-2015, 08:20 AM   #1
gump74
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 09:08 AM. Reason: added more detail
 
Old 11-17-2015, 04:48 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 25,592

Rep: Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880Reputation: 5880
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
 
Old 11-17-2015, 07:03 PM   #3
gump74
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.
 
  


Reply


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 04:04 PM
NTOP Error Traversing Database for ipnum = - Perhaps database is corrupt? soslinux Linux - Networking 2 03-03-2010 06:28 AM
DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error kaplan71 Linux - Software 3 06-05-2009 12:39 PM
(my)sql: drop database doesn't remove database kpachopoulos Programming 3 09-19-2007 01:32 PM
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 08:20 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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

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