qlserver" | sed 's/^.*=//'`
mysqldatadir=`grep '^[ ]*datadir=' "$realmysqlserver" | sed 's/^.*=//'`
As you might guess, I use a technique like this to locate the MySQL
data directory in scripts I run overnight to check the databases
and manage backups.
This sounds like a good candidate for the two-table model:
Table 1 contains an ID and the basic names.
Table 2 contains the 1-many relationship of basic name entry mapped to
all the variants - one record per variant.
So you might have Table 1 containing
ID, Prefix, GivenNames, Surname, Suffix
