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?
Comments
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.