1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL - checking database

Discussion in 'Troubleshooting and Problems' started by snowman, Jul 10, 2011.

  1. snowman

    snowman Member

    Hello -

    When I was trying to find the table name of the import table to resolve a direction issue, I used the "Checking Database" feature of MySQL. When it checked the xenForo database, I got many "Table upgrade required" errors. Here are some examples:

    So it was a mixture of OK's and Errors.

    Is this anything to worry about? My installation is from yesterday. If this is not accurate information insofar as any errors with the database, is there a tool we can use for xenForo to check these things more accurately?

    Repair table wasn't able to repair most of them when I tried to run it.

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Did your host or server person recently upgrade MySQL? From what version to what version? Upgrading MySQL can trigger this error for existing tables. Normally a repair would fix this, but INNODB tables don't support repair so this error doesn't make sense.

    I did some searching and found this to be a bug:


    I see two fixes:

    1) Recreate your database using a backup taken before MySQL was upgraded (assuming you made a backup before the upgrade).

    2) Upgrade the tables using ALTER TABLE. I see these two forms suggested:

    ALTER TABLE table ENGINE=innodb;
    snowman likes this.
  3. snowman

    snowman Member

    Thanks for your response Jake -

    Yes, the server was experiencing other issues related to the versions of PHP and MySQL and the library when it was compiled (Server error 246). So the host updated and recompiled PHP to 5.2.17 and MySQL to 5.1.56. Previously, MySQL was at 5.0.92 - Community.

    This was a new install that imported from vBulletin. The original vBulletin database was created before the MySQL upgrade but that seems like a major undertaking of reinstalling everything from scratch again.

    I would like to try to upgrade the tables I think using ALTER TABLE. What tool do I use to issue this command? I really don't know much about MySQL databases or how to work with them. Should I ask the host to do this?
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That would be best.

    You can run the query using phpmyadmin or the mysql prompt in the shell (requires shell access to the server). The query needs to be run for each table.
  5. snowman

    snowman Member

    Thanks again Jake ... as luck would have it, MyPHP for some reason will not load. I sent a note to my host but they have not responded yet. Will Navicat Lite be able to to run the query remotely? I never have much luck trying to do things in the shell.
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I have never used that program. I went to their site and it appears to be another MySQL admin tool. You should be able to run the query in that program.
  7. snowman

    snowman Member

    I downloaded it (Navicat) and was unsuccessful in connecting to my website with it. =(
  8. ragtek

    ragtek Guest

    Is remote access enabled on your mysql server?
  9. snowman

    snowman Member

    I would have to check into that. I'm not sure. I didn't get that far in Navicat. I got a variety of errors trying to configure the connection settings.
  10. snowman

    snowman Member

    My host performed the suggested "ALTER TABLE <table> FORCE" command on all tables that returned an error regarding upgrade. At this time, I am able to perform a MySQL Check on the xenForo database and receive all "OK" responses. So it appears this did resolve the issue. Thanks again for your help Jake!
  11. Floris

    Floris Guest

    Mind you that some tables are MEMORY (especially '*_view' ones), others do seem to be MyISAM (i think session* ones and search_index)

Share This Page