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/Counter.inc.php on line 11
Warning: mysqli_connect(): Error while reading greeting packet. PID=92999 in /Library/WebServer/Documents/Owen2/Inc/Counter.inc.php on line 11
Warning: mysqli_connect(): (HY000/2006): MySQL server has gone away in /Library/WebServer/Documents/Owen2/Inc/Counter.inc.php on line 11
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /Library/WebServer/Documents/Owen2/Inc/Counter.inc.php on line 12
Could not connect to MySQL: