Database broken

Hi there,

my UNA site broke down today. Only had a red "Database query error" instead the community.

When I try to export the database via Plesk it says

  • mysqldump: Got error: 1017: "Can't find file: './ppc_una/bx_timeline_hot_track.MYI' (errno: 2 "No such file or directory")" when using LOCK TABLES
  • ("program 'mysqldump' finished with non-zero exit code: %d", 2)

and I check my /var/lib/mysql/ppc_una/ and there's a bx_timeline_hot_track.frm but that is it. No MYI or MYD.

What should I do?

  • View
    1723
  • More
Replies (3)

    • Hello trunky !

      Try to apply this query in your UNA database:

      repair table `bx_timeline_hot_track`

      and check the free space on your MySQL server.

      • T

        space is enough free. SQL command says it can't find "bx_timeline_hot_track.myi"

        Are there any "important" data inside? Or can I try to remove and recreate it?

        • T

          so I removed the bx_timeline_hot_track.frm from server, recreated the database with the three columns and it seems to work.

          Login or Join to comment.