Difference between revisions of "Add video file extensions"

From LinuxMCE
Jump to: navigation, search
m (Undo revision 24350 by Rebeca312 (Talk))
Line 33: Line 33:
  
 
''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

Revision as of 16:17, 13 July 2010

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