Deleting videos from DB

[uaker1488]

Hi.

Imported too much videos to TCMS. Server is not responding properly. Can't delete videos from admin panel.
Can you please tell me, from which tables should I delete videos? Delete all of them is not an option, I will lose rotation results.

What I'm asking for, is sql query that is used when I'm deleting a thumb from TCMS

Thanks

[admin]

Hi,

too many is how many?

sql: delete from rot_gallery_info ....

[uaker1488]

Hi. Over 800k. I mean not too much for SmartCJ, but to much for my server
Thanks!

[admin]

what queries are slow?

[uaker1488]

It's not about slowness. Big amount of videos and tags is too much for my low-RAM server It says that some temporary table is full, couldn't even enter List Thumbs page in admin panel. Anyway, already deleted everything from Settings -> Special

[admin]

I see , ok