Aadhaar card

You could wait or else for temporary fix, you can hide the notice by adding define(‘WP_DEBUG’, false);
to your wp-config file.

For that, you need to have a copy of your wordpress database in your test environment too, i mean your localhost xampp. Then you can see its blog posts.

First of all, Don’t bump that many times, if you need immediate assistance, you can hire WP professional.

Your sitemap is loading fine to us. Make sure, your robots.txt is not blocking Google bot.

Seems like this issues is causing due to the theme. Switch to your default theme and if you need help with your current theme, you can ask in his support forum.

In your homepage your buy link is like this
https://www.sparrowtraps.net/cgi-bin/shopper.cgi?search=action&keywords=all

And in your new wordpress installation menu, you set the buy link lead to
https://sparrowtraps.net/wordpress/buy/

So that’s why it is returning a 404 error.

You can keep the name as buy in the menu, but the link should be like the one in your first domain.

Create your sub domain in your cpanel and then install the wordpress manually like you did before.

Seems like it is returning 404 error and so redirecting to your home page.

Because the links
https://sparrowtraps.net/wordpress/buy/
https://sparrowtraps.net/wordpress/sparrow-spookers/

does not contain anything, so they are returning 404 error.

Do you really have any files in the folder
/wordpress/buy/ ?

Have you tried this in a new browser by clearing your cache? I mean your new wordpress site?

You need to make sure that your header has the following code for title
<title><?php wp_title(”); ?></title>

Otherwise it will show two times

Maybe your time zone and your server time zone are different. This usually happens to me also, I set my posts to publish at certain day, but they will get published by the end of the day.

I assume you are asking about how to make your local server live. For that you need to have a dedicated IP. If you have that, you can register your domain name with that IP and it can be accessed by all over the world.

Or simple share your IP to others and they can able to access your wordpress site.

Open your command prompt and move to your mysql installation folder. If you are using windows, your path will be like this

C:\wamp\bin\mysql\mysql5.6.17\bin

Now, run the command what i gave you in the above to import into your database.
mysql -u username -p databasename < file.sql

While adding a new post, you will be asked for SEO title, you can use whatever you want under Yoast Seo Settings while adding new post.

You have entered wrong details of your database in wp-config.php . Update it with correct database settings, it will work.

Yes! You can download & install mysql separately and use the mysql server for your use.