Difference between revisions of "Add video file extensions"
From LinuxMCE
| (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:'' | ||
| − | + | ||
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 | ||
| − | |||
| − | |||
| − | |||
| − | |||
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
