I just run into problem of having a site under subdomain and moving it to live domain. Image paths in file table were all wrong, but there is simple fix for this.
UPDATE files SET filepath = REPLACE(filepath, 'old/path', 'new/path');run this in phpmyadmin and chage paths completly, something like is what I used
UPDATE files SET filepath = REPLACE(filepath, 'sites/mov.arabba.hr/files/', 'sites/miomirisni-vrt.hr/files/')