I have been working on my website and storing information in the database. I changed the type of several of the tables from MyISAM to InnoDB. Since the change, several of the pages will not load. Everything worked fine at Noon ET on 12/2/2021. After the change, only a few pages load. Can the DB be restored or can you direct me to how to fix it? I’ve tried changing the type back, but it doesn’t seem to do any good.
Unfortunately, backups are not taken here (They are on Premium hosting though), so there is no way (that I know of) to revert your database to a previous version. Changing they type of database can break some things depending on your setup, but without more information on how your code works I cannot really tell you want to expect, or how to fix it.
I’m really new at this, and the code is pretty basic. What I don’t understand is that some of the pages work, and some don’t – even when they use the same tables. There are two php pages – one is to enter stats and one is to view the stats. One barely loads and the other loads but is missing some buttons. Neither page was editted today.
Then there is another page that pulls some information from the same DB table. That one works.
All the information in the table was test information. If I recreate the table, would it likely start working?
Thank you for your help. I discovered my problem. It wasn’t that I changed the Tables. I had forgotten that I deleted a table that I wasn’t using – although I really was. It was a simple two-column table with six simple rows of data. I added it back and everything worked fine.
