HOW to set to PRIVATE videos in bulk from admin panel?

[frak]

i have 1000's of PUBLIC videos waiting for me to be approved from my ADMIN panel.However i want to approve all of them as PRIVATE.

How i can do that from ADMIN or mysql database?

thanks

[hostonnet]

You can do it with mysql query

update videos set video_active=1, video_approve=1, video_type='private' where video_approve=0;

Take a database backup before doing this.

[frak]

Take a database backup before doing this.

my db is bigger than 160MB , what kind of backup u suggetst?
from cpanel/backups

or

phpmyadmin/export

if i am not wrong,if a restore is neede, i ll be able to import max 50 mb from there? mine is 164mb:)..

any suggestion really appreciated:)

[hostonnet]

Cpanel back will be better for large database. For restoring, use bigdump

BigDump: The Staggered MySQL Dump Importer

[frak]

i ve tried:
update videos set video_active=1, video_approve=1, video_type='private' where video_approve=0;

and

update video set video_active=1, video_approve=1, video_type='private' where video_approve=0;

result:

#1146 - Table '********_vshare.videos' doesn't exist
#1054 - Unknown column 'video_approve' in 'where clause'

[frak]

any update on this.. please?

[hostonnet]

What version of vshare you are having ?

[frak]

it's vshare 2.6

[hostonnet]

contact [email protected] with your cpanel login details and url of this post, we can check this.