when having to reupload an entire database with 2,000+++ posts the best idea is to download the post and its relating tables seperately and upload that sql file
or just open the full database download and find it and make it into its backup file

it makes things alot easier
and also when restoring a database, dont add the postindex rows back just the table

use the rebuild postindex function after successfully reinstalling a database