18
Hello,
I use both backpack and backup modules to backup. All seemed to be running well until I tried to backup yesterday. Here is what I get when trying to backup with the backup module:
SHOW FIELDS FROM databasename.tableprefix_avatarTable './databasename/tableprefix_avatar' is marked as crashed and last (automatic?) repair failed
I know very little about databases or how to repair tables. I did go into phpMyAdmin but I don't know how to repair and the message in phpMyAdmin when viewing the avatar table is:
Error
SQL query: Documentation
SELECT *
FROM `tableprefix_avatar`
LIMIT 0 , 30
MySQL said: Documentation
#144 - Table './databasename/tableprefix_avatar' is marked as crashed and last (automatic?) repair failed
I have a recent backup and it shows all the dumping data and table structure for the avatar table. Is there a way for me to fix or restore the avatar table? The backup is not recent enough to use in other areas so I wouldn't want to restore with the entire backup - just the problem table.
The avatar table is the most important issue (I think) at the moment but I have found other issues as well such as a partial registration with no user profile. So the only thing in the database is the user but not their profile info. When I try to pull up the user ID in XOOPS admin, there is no info, as if the user does not exist. The good news is there has been a successful registration since then but I still have that incomplete user in the database and will need to know how to delete without issue.
There are other issues showing when I ran the TableCheck module. I suspect it has to do with either a recent server move and/or deletion of a large amount of users from the database.
I am running a XOOPS 2.2.4 site. Unfortunately, I cannot upgrade at this time but would like to in the future.
PHP version 5.2.10, MySQL version 5.0.67
I hope someone can help me soon as I cannot backup properly and fear the issues will get worse if I put it off much longer.
Thanks,
Hope