Required to restore the site in PHP Mysql

Required to restore the site in PHP Mysql. Database – 1 million records.
In the future you need to write a new program based on SEO, increasing search speed, morphological matching words from a search query.
Preferred personal