Delete media from database

I am using 1.7.3 version. Media library have about 5000 files. I need to delete old files from media library, but there is no option for deleting multiple files at once. Is it possible to delete from database (media table) directly, does it affects any other table?

Thanks.
Michael.

You mustn’t delete files manually. There are other tables that reference it.

1.7 series has a library tidy routine which you can run, which will delete any media not assigned to a layout currently. You could run that.

I’d suggest upgrading to 1.7.9 before you do though so that any bugs with that routine won’t cause you an issue, and as ever, take a full backup of your media library and database before running that routine.