I’m using OJS to run a journal site.
This is being run on a Windows 2003 server, 32-bit, with IIS 6 hosting the site, and MySQL 5.1 storing the data (also on the server).
I had to restart my server last night, and after the restart, the MySQL service was hung in a starting state. To correct the problem, I took a backup of:
and then deleted those files from C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data
I then restarted MySQL (which took around 20 minutes to complete), which created new files with those same names, but with a drastically smaller size for the ibdata1 file (10,240KB, down from 26,624KB).
After the service restart, I went to the site homepage, and saw the following error message:
DB Error: Table 'ojs.sessions' doesn't exist
I saw a posting here about that issue (viewtopic.php?f=8&t=734
), but I’m not sure this applies to my situation. I haven’t performed any upgrades recently.
When I load the database in MySQL Workbench, and run the query “SELECT * FROM ojs.sessions;” I’m getting the same error message “Error Code 1146. Table ‘ojs.sessions’ doesn’t exist.
I am not a MySQL expert, but I’m stumped by this. If I can browse to the table in MySQL Workbench, how can it not exist? The table definitions are stored under C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\ojs, and in that folder, I see all the .FRM files for the tables.
I’m at a loss as to how to restore my data, if it has in fact been lost. Do I just need to roll back to the archived copy of ibdata1 and try again?
Thanks in advance for your help with this.