Hi Rick,
>In my C code, I use SQL statements, but I use the mySQL C API to pass on the
>SQL statements, check for errors, number of rows returned, and access the
>results. I would assume that this will still work; they still work with BDB
>tables.
ok, it should work like for BDB. There may be small differences when
the API tells you the number of rows deleted or updated, because I have
not had time to check that these numbers exactly agree for diffrent table
types. Also SHOW TABLE STATUS will return different numbers, because for
example the row count is only approximate in Innobase, calculated from
a small sample of the table.
>I noticed in many list comments about others having problems with corrupt
>tables (MyISAM), and having to repair them. Since you don't have any such
>tools, can I assume that you are not having any problems with data loss or
>corrupt tables?
I have not noticed table corruption in my own tests of Innobase since last fall.
But, of course you have to take backups regularly. You should also use mysqldump
to take logical (= text format file) backups of your tables. In case of table
corruption you can recover from a backup using the MySQL log. The safest backup
to use in recovery is the logical backup produced by mysqldump.
I do not think a repair table procedure is the best way to implement
safety, because neither MS SQL Server nor Oracle have such a procedure,
and there is a vast user base for those databases. Recovering from a backup
is a more reliable way.
Remember that Innobase uses transactions and logging. From a benign
server process crash it will automatically recover using the log files.
Table corruption will only result from a bug in the low-level source code,
or a media failure of the disk. I have crashed Innobase hundreds
of times this winter during my development work, and it has always
been able to revover from the log files.
Regards,
Heikki
>Thanks,
>Rick
---------------------------------------------------------------------
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
