Results 1 to 6 of 6

Thread: DB Tables: in use

  1. #1
    evetools is offline Junior Member
    Join Date
    Jul 2014
    Posts
    21

    Default DB Tables: in use

    About an hour ago some of the tables in my DB have "disappeared" and cannot be accessed. When I check with phpMyAdmin, I see some tables fine and some are marked 'In use' and cannot be accessed. What's happening?

    See here:

  2. #2
    evetools is offline Junior Member
    Join Date
    Jul 2014
    Posts
    21

    Default

    Update:
    It looks like all of my tables were converted from InnoDB to MyISAM? When I try accessing some of the 'In use' tables, I get: #1286 - Unknown table engine 'InnoDB'

  3. #3
    evetools is offline Junior Member
    Join Date
    Jul 2014
    Posts
    21

    Default

    Update:
    From what I could figure out by now: INNODB support on my site was turned off all of a sudden, rendering all my tables suddenly corrupt. I cannot restore from backup (cause all the backup is InnoDB) and I cannot recover. This was done without notice or warning on a Friday night without any support expected for several days. What the hell? This is an extremely unprofessional move, Altervista. What kind of a business are you guys running? Even in the unlikely case I would be able to recover my lost DB tables from backup - data has been lost.

  4. #4
    karl94 is offline AlterVista Staff
    Join Date
    Jan 2015
    Posts
    573

    Default

    We checked your tables and found no issue with them, InnoDB support hasn't been deactivated.

  5. #5
    evetools is offline Junior Member
    Join Date
    Jul 2014
    Posts
    21

    Default

    There was no change in my tables cause I spent the weekend recovering from backup and filling in the lost data.
    Tables were all switched from InnoDB to MyISam. Why?

  6. #6
    Gianluca is offline Administrator
    Join Date
    Feb 2010
    Posts
    512

    Default

    evetools:

    there is no reason we should have turned off innodb for your database, no manual operation was performed on it.
    Phpmyadmin may have shown a wrong engine when these tables were marked as "in use", this happened because you may have hit a mysql bug and while this issue is under investigation your website has been temporarily moved to another server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO