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

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

You can do it with mysql query

Code:

---

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

---

Take a database backup before doing this.

Quote:

---

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:)

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

BigDump: The Staggered MySQL Dump Importer

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'

any update on this.. please?

What version of vshare you are having ?

it's vshare 2.6

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