Hi, sorry to bother, I made it, so no help needed ?? For those who maybe find it helpful in the future.
I made a copy of the database from my other version of the same website. (It is on another server and I am planning to rid of that domain, that’s why all the hustle). So, using the host provider to backup the database I did, then, I created another database on my new hosting account and imported it into a fresh new DB. Everything worked including that troubled image. But the links we all pointing to my old website. Then I went to the posts table and make a query UPDATE wp_posts SET post_content=(REPLACE (post_content, ‘old site.com’,’new site.com’)); After hat all works fine. Me happy! P.s. also need to change in option table old site —>new site