How to transfer database to another WordPress site

http://test.com is the old domain, https://site.com is the new one.

UPDATE wp_options SET option_value = REPLACE(option_value, 'http://test.com', 'https://site.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://test.com', 'https://site.com');
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://test.com','https://site.com');

UPDATE wp_posts SET guid = REPLACE (guid, 'http://test.com', 'https://site.com');

UPDATE wp_comments SET comment_content = REPLACE (comment_content, 'http://test.com', 'https://site.com');
UPDATE wp_comments SET comment_author_url = REPLACE (comment_author_url, 'http://test.com', 'https://site.com');

guid – global identifier for RSS.

change wp_ to the one you have, how to change it see here.

If you have any questions or suggestions, feel free to message me on Telegram @g3nnadych or LinkedIn.