Difference between revisions of "Add video file extensions"

From LinuxMCE
Jump to: navigation, search
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 +
[[Category:Media]]
 +
 
=How to add valid file extensions for new Video formats=
 
=How to add valid file extensions for new Video formats=
 
LinuxMCE maintains a list of video extensions in the "MediaType" table of the "pluto_main" database.
 
LinuxMCE maintains a list of video extensions in the "MediaType" table of the "pluto_main" database.
Line 33: Line 35:
  
 
''At a terminal prompt, type the following:''
 
''At a terminal prompt, type the following:''
''[http://www.superiorpapers.com custom research papers]
+
 
 
1.)
 
1.)
 
  mysql -u root pluto_main
 
  mysql -u root pluto_main
Line 39: Line 41:
 
  update MediaType set extensions=concat(extensions,',flv') where define='pluto_StoredVideo';
 
  update MediaType set extensions=concat(extensions,',flv') where define='pluto_StoredVideo';
 
  quit
 
  quit
 
 
 
[[Category: Tutorials]]
 

Latest revision as of 16:38, 19 October 2012


How to add valid file extensions for new Video formats

LinuxMCE maintains a list of video extensions in the "MediaType" table of the "pluto_main" database.

How to do it

At a terminal prompt, type the following:

1.)

mysql -u root -D pluto_main <enter>

Password for "root" is <blank> by default. You'll now see a "mysql>" prompt

2.)

select Extensions from MediaType WHERE Define = "pluto_StoredVideo"; <enter>

You should see a result like this:

+---------------------------------------------------------+
| Extensions                                              |
+---------------------------------------------------------+
| mov,avi,mpeg,mpg,wmv,ts,tp,dvd,vdr,ogm,evo,m2ts,iso,mp4 |
+---------------------------------------------------------+
1 row in set (0.00 sec)

3.)

UPDATE MediaType SET Extensions = "<Insert Result from #2 here>,<new fileext sep by ,>" WHERE Extensions = "<Insert result from #2 here.>"; <enter>

For Example: UPDATE MediaType SET Extensions = "mov,avi,mpeg,mpg,wmv,ts,tp,dvd,vdr,ogm,evo,m2ts,iso,mp4,mkv,bin" WHERE Extensions = "mov,avi,mpeg,mpg,wmv,ts,tp,dvd,vdr,ogm,evo,m2ts,iso,mp4";

4.)

quit <enter>

Another way

If you need to add the flv extension:

At a terminal prompt, type the following:

1.)

mysql -u root pluto_main

2.)

update MediaType set extensions=concat(extensions,',flv') where define='pluto_StoredVideo';
quit