posted
Your index is corrupted. You need to try 'repair table phpbb_users', and possibly mysqlisamchk. Another possibility is a file access problem, though that's unlikely (check the permissions on that .MYI file)
If the table is still gone after those (check phpmyadmin -- install it if you haven't yet), your forums likely came with some sql code to populate the databases originally -- find that file, copy and paste the lines for that database into a new file, then inject that file into your database.
Posts: 15770 | Registered: Dec 2001
| IP: Logged |
posted
I fixed it. I had made a backup of the whole forum not too long before it crashed, but I didn't want to drop any posts that may have happened between the backup and the crash so I just cut-and-pasted in the SQL commands from the backup.
I haven't actually been able to locate the files for my databases, I do all my administration through my host's web control panel. fugu, are those SQL commands or are they shell commands?
Posts: 4534 | Registered: Jan 2003
| IP: Logged |
posted
Hmmm... Apparently the web client I use for database admin is phpMyAdmin (v. 2.4.0), but it sounds like you're talking about a shell application. Man, I wish my office firewall would let me connect in any way other than the web...
Posts: 4534 | Registered: Jan 2003
| IP: Logged |
posted
The first is an sql command, the second a shell command. Put a colon on the end of the sql command to run it.
I think phpmyadmin may be able to run the shell command, but I'm unsure and don't have easy access to an install right now.
Posts: 15770 | Registered: Dec 2001
| IP: Logged |