Difference between revisions of "Add video file extensions"
From LinuxMCE
m (→How to do it: Updated text to note default) |
|||
| (5 intermediate revisions by 5 users 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 | + | LinuxMCE maintains a list of video extensions in the "MediaType" table of the "pluto_main" database. |
==How to do it== | ==How to do it== | ||
| Line 6: | Line 8: | ||
1.) | 1.) | ||
| − | mysql -u root - | + | mysql -u root -D pluto_main <enter> |
''Password for "root" is <blank> by default. You'll now see a "mysql>" prompt'' | ''Password for "root" is <blank> by default. You'll now see a "mysql>" prompt'' | ||
| Line 29: | Line 31: | ||
quit <enter> | 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 | ||
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
