Broken MySQL databases

[ntadej]

All my mysql databases are broken. Is there a way to restore them, because I don't have any recent backup.

 

[stpvoice]

When you say broken-what do you mean?

Do you mean there is data missing, or they have been rolled back to a previous period?

 

[ntadej]

I'm getting errors like this:

#1033 - Incorrect information in file: './ntadej_main/phpns_comments.frm'

I think migration to new mysql servers is the problem.

 

[descalzo]

1. Which server?
2. Were they innoDB tables?
3. If you look at them in phpMyAdmin does it show them as 'views' rather than tables?
4. When did the problem start?

 

[ntadej]

1. chopin
2. They were created using cPanel's ''Create New Database''.
3. They look like tables but under Records/Type/Collation/Size/Overhead I see ''in use''
4. I didn't look at my page recently but I saw information about new MySQL servers and it didn't work since then.

 

[stpvoice]

You need to attract the attention of staff so they can check your account for faults.

 

[ntadej]

I found 2 months old backup on my PC and will restore it.
Thanks for your help anyway.

 

[stpvoice]

Okay
You may find there's a problem with the MySQL setup on your account, not the actual databases, so a restore wouldn't do much good.