Revision as of 16:43, 22 June 2008

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