I started off on the wrong foot. First a single site WP installation in a subdirectory called "wordpress" years ago.
Then Multisite a few months ago.
Then I moved the whole installation to public-html root.
Then I deleted 2 sub-domains and could not re-use them. (by mistake)
From bad to worse but ..
ATTEMPTED TO FIX
To fix the problem, I deleted everything from public-html and reinstalled. Clean root and no sub-directories.
But I could not re-use the deleted sub-domains. My sub-domain numbers in mysql now start with 10, 11, 12 and so on.
Where would any record have been kept, if not in mysql. I deleted all mysql data bases and reinstalled with a different name.
Where is mysql 1 and 2 stored.
Why cant I re-use a sub-domain name after a clear re-install.
Is is practical (and will it work)to ask my SP to delete the whole apache installation and let me start again on the right multisite basis, or is there another file I can delete of reconfigure?