DogMan

David, Thanks. I was able to use Notepad ++ to get the desired results. I appreciate all your input and willing ness to help. I also enjoyed learning a little more about you personally. I always find it interesting to hear the life experience someone comes from, and how they bring that experience to the table.

I think I might be able to do it in Notepad with a simple Find/Replace. I know I can with the GIVN and SURNAME. It is just the process now to get that to properly reflect with the NAME and not have to do so per individual entry. I have 10's of thousands of entries and my server has given an update by date, so individual entry repair is not a feasible option given my constraints. I tried going to your website and all that came up was an IP address.

Good to know. I love redundancy.

Good to know. I love redundancy.

Hello David, Glad to have you in the discussions. My nature is if it isn't broke don't fix it. My server host seems to subscribe to a different mindset though. Since I am beholden to their required upgrades, life is what it is. My nature is also: when faced with adversity - learn. So, I am in the process of changing my mindset from anxiety and fear to openness and excitement. Gerry has actually suggested text editing. His position may be like most things in life: solutions are often situational....

Thanks Gerry, I have sent an email yesterday (2/22), but it may have went to spam. I look forward to your response and being able to discuss everything in a more private manner. It's good to know that MySQL 8 will not be an issue. I am very comfortable with Find/Replace using Notepad, MSWord, Access. That is how I thought someone might handle such a switch. Especially with larger datasets. I am just a little confused on the separation and correlation between the MySQL database and the GEDCOM. Until...

When I began the project decades ago, it was for private purposes. I was new to the process, had little understanding, and was (fast track) self-teaching to develop a way to reach a specific end goal. In short, I was working from the big picture backward. My whole life, I have been a fixer. Oftentimes, on projects, I simply have the end result, certainly no directions, and I have to take the object apart in (perceived) reverse order of its build to find any potential issues and then build back often...

Thanks, I raised it to 256. My database is a lot larger than 6,000 but 256 seemed to work. I also adjusted the Session Timeout to 7200 and when importing set the time limit to 360. That all worked and I now have all the sexes. That is super helpful. Thanks. In my database I have a lot of singular names. For example, if there was a John Tylor but all I knew was John I included just John (in many cases with no other relatives). Under this scenario if I ran into another John with a missing last name...