Hi @HaripriyaSathiish,

This issue seems related to either database corruption during migration or compatibility with PHP 8.0 and MySQL 8.0. As @phucbm pointed out, checking the wp_posts table is a good start. Ensure it has proper AUTO_INCREMENT and primary key configurations.

Additionally, check these if -

Disable Plugins - Rename plugins and mu-plugins to rule out plugin-related errors, as @HowardE mentioned.

Database Re-import - Re-import the database using the --force flag to bypass incomplete logs.

Test Compatibility: Switch to earlier version of PHP that 7.4 temporarily to see if the issue is resolved.

For detailed steps on WordPress migrations, check this https://www.wpbeginner.com/beginners-guide/ultimate-wordpress-migration-guide/ let me know if all works