Update Drupal files path in database manually

Move Drupal site from one subdomain to another subdomain in multisite Drupal installation easy with manually updating files path in database.

UPDATE files SET filepath = REPLACE (filepath, 'old/path', 'new/path');

Source