Hello,

First of all, great module! I have over 500 flash videos with the .flv extension on my live website. I've converted all of those videos on my workstation to .mp4 . I'd like to upload the .mp4 videos and use them instead of the current .flv because HTML 5 is becoming the standard.

The fastest way I could think of doing this is to FTP in and delete all the .flv files and FTP all the .mp4 files into the videos directory. Then change the file extension from .flv to .mp4 in the database.

What MYSQL command do I use to change all video extension from .flv to .mp4 ? Is there a better way of doing it?

Comments

Jorrit’s picture

Jorrit commented
Status: Active » Postponed (maintainer needs more info)

Do you use transcoding or do you display the file exactly like it is uploaded? If transcoding, what transcoder do you use?

prokopton’s picture

prokopton commented

I uploaded the files exactly as they were. No transcoding.

Would you know the MySQL command to change all .flv file extensions to .mp4 in the videos module?

Thanks.

michael.k’s picture

michael.k commented

You could run SQL queries in phpMyAdmin (don't forget to back up first!):

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");

For changing the path for files:
UPDATE drup_files SET filepath = replace(filepath,"sites/default/files/images/example.png","sites/default/files/images/test/example.png");

For changing multisite paths to default site paths:
UPDATE drup_files SET filepath = replace(filepath,"sites/example.org/files/","sites/default/files/");

prokopton’s picture

prokopton commented

Thank-you Michael and Jorrit! I'll give that a try. I hope HTML 5 is the next and last web standard. So much time is consumed with compatibility issues rather than creating content and building apps.

bkat’s picture

bkat commented

Are you providing flash fallback? there is no single codec that works across all browsers. At a minimum, you need to provide an mp4/h264 and a webm/vp8 version.

http://en.wikipedia.org/wiki/HTML5_video

prokopton’s picture

prokopton commented

By the looks of it, all the major players have settled on H.264.

http://news.cnet.com/8301-30685_3-57397031-264/mozilla-execs-capitulate-...

Jorrit’s picture

Jorrit commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

I think this issue can be closed as the question has been answered.

nicberweky’s picture

nicberweky commented
Issue summary: View changes

Change file extension will not always work.

Why dont you simply download some Video converter to convert FLV to MP4 from web. Few i can suggest you if Faasoft FLV to MP4 Converter.

Here is a quick guide on how to convert FLV to MP4 with it on Mac and Windows.

Hope it is what you are looking for.

aimkeepachieve’s picture

aimkeepachieve commented

After long google search and comparison, I find an simply way to batch convert FLV to MP4 with high quality on Mac or Windows

After had a try, i find it really works great in converting FLV to MP4,

It also can convert FLV to MOV, AVI, WMV, MKV, WebM, OGV etc.

More exciting, it even helps to directly download YouTube FLV video to MP4.

Hope it is what you are looking for.

daphnerombach’s picture

daphnerombach commented

If you want to batch convert FLV to MP4, you can turn to Video Converter program. It's quite easy to use which enables you to convert videos in just three simple steps. Here is a guide you can refer to: How to Convert FLV to MP4.