wordpress database migration change Steps

first go to wp-config.php file and change database name(what you want)
1. wp_1_options -Table name
option_name column – change(siteurl and home)

2. wp_blogs- Table name
domain column – change

3. wp_site- Table name
domain column – change

4. wp_usermeta
meta_key column – change(source_domain)

use this for
changing all post path and image path
UPDATE wp_1_posts SET post_content = REPLACE(post_content, ‘purab.wordpress.com’, ‘localhost.localdomain’);