by evilgenius » Fri 26 Aug 2016, 11:17:26
It still looks like a programming over a server error. For instance, when I clicked on this forum to view it, in the Member View, while looking at the first page I saw in the section to the left of the posts the log-in prompt instead of my avatar image and welcome greeting. Then, when I clicked to go to the second page, I saw my avatar image and welcome greeting. It acts like the session has set the cookie, but certain partial views have got something wrong in not recognizing the user level setting as appropriate to allow them to function as one would expect. It acts like the user level that is set is inappropriate to allow that. Before, this behavior was rampant. Now, it is more confined.
MySQL is practically the backbone of the internet. I can't see how you could have a problem migrating the old server instance to a new one, unless there is some kind of version conflict or setting gone wrong in the new setup. If the old server is still up you can export a sql script that will capture the entire site. Depending upon what type the old instance was, innodb or whatever, you can also copy the pertinent files over and put them into the proper places in the new instance as well. The files go into different places depending upon which type you are dealing with. You have to get them all as well, or you will only capture a portion of the information, like tables only, but table names only and no columns, or no data. Strangely, I was just looking up this very issue the other day for something I had to deal with on my own localhost, after upgrading to foul Windows 10. I found the answer using Mr. Google. My problem was I had already set up some other database instances for some other projects on the new server, and the innodb stuff I used to set them up is all in one file. I couldn't migrate the old instance with a file swap or my new stuff wouldn't be there. With just one database instance to worry about you shouldn't have that problem, though. However, since there is something of the history of the site here, it looks like you did get around that with no problems. I just offer that as a reassurance that you don't need to abandon MySQL. There is a config thing in MySQL where you can enable so many connections. I've seen it I don't know how many times when I've been poking around, but I was always doing something else. That could be what you have to do.