Unfortunately that won't work on the majority of the damaged tables (in my experience). They need to be dumped and reloaded. That's the annoying/dangerous thing.
Faris.
Upgrading Plesk 9.5.4 MySQL
Re: Upgrading Plesk 9.5.4 MySQL
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: Upgrading Plesk 9.5.4 MySQL
Works fine in the majority of cases in my experience. If a REPAIR doesn't work, then usually the data is really corrupted and it's also no longer possible to create a correct dump. YMMV, you can always give it a shot.
Lemonbit Internet Dedicated Server Management
Re: Upgrading Plesk 9.5.4 MySQL
Thanks Breun (as usual!)
I'm going from memory here, but as I recall a lot of the tables that get into this state give an error similar to "table type (whatever it is) does not support repair - dump and restore instead". That's paraphrasing the error -- it is something else really.
In one of the posts there's something similar. It says
but this isn't precicely the error I'm thinking about.
I'm going from memory here, but as I recall a lot of the tables that get into this state give an error similar to "table type (whatever it is) does not support repair - dump and restore instead". That's paraphrasing the error -- it is something else really.
In one of the posts there's something similar. It says
Code: Select all
psa.subdomains
note : The storage engine for the table doesn't support repair
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: Upgrading Plesk 9.5.4 MySQL
Not all storage engines support REPAIR, that's correct. According to http://dev.mysql.com/doc/refman/5.1/en/ ... table.html only MyISAM, ARCHIVE and csv tables support REPAIR. See http://dev.mysql.com/doc/refman/5.1/en/ ... ables.html for more information on repairing tables.
Lemonbit Internet Dedicated Server Management