Hello Michael,
Friday, January 26, 2001, 12:20:43 AM, you wrote:
MW> Hi!
>>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter>> Hello monty,
Peter>> As I remember according to documentation MYSQL should support check
Peter>> table on BDB tables:
Peter>> `CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM'
Peter>> tables it's the same thing as running `myisamchk -m table_name' on the
Peter>> table.
MW> I tried to implement this; I had got everything coded when I
MW> noticed the on can only check BDB tables when there is no active
MW> transaction and one is the only one that is using the table. This
MW> is impossible to guarantee with the current MySQL code; To do this we
MW> have to add a new layer on top on transactions, which isn't something
MW> we plan to do until in 4.x
MW> I have now removed the notes about BDB tables in the CHECK command.
OK. But just note to really use BDB tables in production people need
to have a possibility to recover data if BDB table somehow got
dammaged. I know there is a chance to recover data by alter table or
if this does not help to do an mysqldump and restore (well of couse
this is worse then with MYISAM there repair table sometimes helps even
then mysqldump does not work). To do the repair you of couse need to
find out something is going wrong and it's better to find this before
the errors will block normal execution.
As far as I know there is no tools now to fix BDB tables (the one
provided with BDB does not work with MYSQL tables) so it was nice
option anyway - to start other mysqld and check the table :) And as
far as I know this is safe anyway as check table does not change
anything in BDB ?
Also - does not lock tables write enshures there are no other active
transactions ?
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
