Fix post featured images

I recently exported my wordpress data from old to new stating site. Due to the large data, I get gateway timeout. So I decided to zip the image folder and extracted it in new hosting “/upload” directory. Then I imported all the posts however all embedded images in posts are showing fine but the featured images appears grey. I discovered that the featured image path is correct but it appends “-1” at the end the image url.

For instance correct featured image path is “domain.com/upload/2023/xyz.jpg” but the import is showing “domain.com/upload/2023/xyz-1.jpg”.

Just wondering if there is a way to remove the “-1” from all featured images. I have over 1K posts.

In case you might be wondering why I didn’t do full backup and restore, my hosting was recently hacked and there was too many SQL injections so trying to avoid sing the migration backup and restore.