I understand the frustration you're facing with the backup and restore process for WhatsApp on your new phone. Here are some steps you can try to resolve the issue:
Check Backup Settings: Ensure that the backup settings on your old phone are correctly configured to include all chats and media. To do this, open WhatsApp on your old phone, go to "Settings" > "Chats" > "Chat backup," and make sure all the necessary options are selected.
Verify Google Drive Backup: Check if your old phone's WhatsApp backup was indeed saved to Google Drive. Open Google Drive on your old phone and navigate to the "Backups" section to see if the WhatsApp backup is listed there. If not, it might not have been uploaded correctly.
Ensure Sufficient Storage: Make sure you have enough space on your Google Drive to accommodate the backup file. If your Google Drive storage is full, the backup might not complete successfully.
Download Correct Backup File: If you have the file "msgstore-2023-07-10.1.db.crypt14," ensure that it's the most recent and complete backup file. If you have multiple backup files, choose the latest one to restore.
Rename the Backup File: Before restoring, ensure that the backup file's name is correctly set to "msgstore.db.crypt14" (without the date). Sometimes, renaming the file to the correct format can help with the restore process.
Restore on New Phone: Transfer the "msgstore.db.crypt14" file to your new phone's internal storage or SD card in the "WhatsApp/Databases" folder. Then, install WhatsApp on your new phone and verify your phone number. When prompted to restore from backup, select the file you transferred.
Try a Local Restore: If the Google Drive restore doesn't work, you can try restoring from a local backup on your old phone. Copy the entire "WhatsApp" folder from your old phone's internal storage to your new phone's internal storage, and then try restoring again.
Please note that restoring from a local backup will only work if you haven't uninstalled WhatsApp from your old phone and the backup file is intact.
If you continue to encounter issues, you can reach out to WhatsApp support for further assistance.