If messages won;t transfer, or Mail shows other inconsistent behaviour, try rebuilding Apple Mail’s database by deleting envelope index files...
Quit from Mail, and return to Finder.
Open the Library folder (either make it visible, or hold down option key while using the "Go" menu, or use the "Go to Folder" command).
Open the "Mail" folder. Open the latest "V" folder (it is "V9" for Monterey, "V10" for Sonoma)
Open the "Mail Data" folder.
Delete all files that begin with "Envelope Index"
Optionally remove saved application state as well. Go to "Saved Application State" in "Library" folder. Find "com.apple.mail.savedState". If it's an alias, find the original and delete it, otherwise just delete it.
Launch Mail again. it will show a window "Message Import". Wait for this to complete.
Warning: mysqli_connect(): MySQL server has gone away in /Library/WebServer/Documents/Owen2/Inc/Log.inc.php on line 8
Warning: mysqli_connect(): Error while reading greeting packet. PID=83517 in /Library/WebServer/Documents/Owen2/Inc/Log.inc.php on line 8
Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in /Library/WebServer/Documents/Owen2/Inc/Log.inc.php on line 8
Could not connect to MySQL: MySQL server has gone away