Edit the vshare database mysql...

**cmedia** · 04-07-2009, 08:56 AM

Hello...

i have vshare 2.6 with some video, in the main server www.sitewithvshareinstalled.com/flvideo some other, the most new, in a secondary external server.

So... i want to change in the mysql database the url of first group of video ,the one who load from www.sitewithvshareinstalled.com/flvideo i want this videos will load from "www.otherdomainexsample.com/dir"

How i can proceed in phpmyadmin to do this? :oops: :shock:

**RAMMSTEIN** · 04-07-2009, 09:13 AM

You like to do this to prevent the hotlinking i think because i had the same problem. You can not do that from phpmyadmin is inside the script and the script is encrypted. Just install lighttpd mod_secdownload flv server to prevent hotlinking. :wink:

**cmedia** · 04-07-2009, 09:28 AM

Originally Posted by RAMMSTEIN

You like to do this to prevent the hotlinking i think because i had the same problem. You can not do that from phpmyadmin is inside the script and the script is encrypted. Just install lighttpd mod_secdownload flv server to prevent hotlinking. :wink:

No, i don't do about hotlink, for that i have htaccess and anyway i guess i dont have hotlink problem...

I have problem in my current hosting, so i have to move to a better one... and in the better one i have fix bandwith...

And because my site generate "good traffic" and i dont have money to invest for a 20-30mb included i have to optimize...

So i want to use the old and bad one, for part of the videos at least.

i take a look in phpmyadmin, i guesss like i asked is not possible to do, but is possible to set up different servers and then change the server id for "N" videos... :mrgreen:

Have to work like this, i guess.

Like this i will set up some servers in my share admin panel, using cip hosting/old space i don't use anymore... and changing the server id in phpmyadmin i will let vshare load the older videos from this servers... :oops:

Anyway i'm able to do this manually 1 videos at time... anyone can suggest how in phpmyadmin edit the video "server id" for a large amount of video all togheter?

thank you.

**cmedia** · 04-07-2009, 10:00 AM

I think is necessary to run a query in phpmyadmin:

Code:

SELECT * FROM `video``server_id`

But i dont know at all how to do this...

I meas "select" only from first video uploaded to N number of video uploaded, and then make change only the "server_id" and set for all for exsample "1" any help please? :oops:

**RAMMSTEIN** · 04-07-2009, 10:30 PM

If you want to change the server id for your video you can do it with>>>>

update `video` set server_id=THE SERVER THAT YOU WANT THEM TO BE where server_id=THE SERVER THAT ARE NOW

example

Code:

update `video` set server_id=1 where server_id=0

**cmedia** · 04-08-2009, 07:26 AM

Originally Posted by RAMMSTEIN

You like to do this to prevent the hotlinking i think because i had the same problem. You can not do that from phpmyadmin is inside the script and the script is encrypted. Just install lighttpd mod_secdownload flv server to prevent hotlinking. :wink:

Thank you, your suggestion about phpmyadimn, work fine.

About this...

What is ?

i guess the server have to be installed the lighttpd and not apache, right?

It is easy to install and make work? and protect much better then apache+htaccess?

best regards.

**RAMMSTEIN** · 04-08-2009, 12:54 PM

Originally Posted by cmedia

i guess the server have to be installed the lighttpd and not apache, right?
It is easy to install and make work? and protect much better then apache+htaccess?

You can have them both in a server and run the lighthttpd from an other port.

About the apache+htaccess hotlink protection is not the best way to protect your videos they can bypass that protection. Take a test and you will see it yourself.

**cmedia** · 04-08-2009, 05:19 PM

Originally Posted by RAMMSTEIN

Originally Posted by cmedia

i guess the server have to be installed the lighttpd and not apache, right?
It is easy to install and make work? and protect much better then apache+htaccess?

You can have them both in a server and run the lighthttpd from an other port.

About the apache+htaccess hotlink protection is not the best way to protect your videos they can bypass that protection. Take a test and you will see it yourself.

Interesting.

And what about bandwith limitation?

for lighthttpd exsist also mod for this wo work good?

I mean limit the video directory to consume not more then certain amount of bandwidth/second...

For apache i have make some searches and the only mod i found is only, last update on 2007

http://www.cohprog.com/v3/bandwidth/download-en.html

so not seems a very good solution... anyway seems this mod do exactly what i ask for.