Re: Table crash!

[Ale Perme]

- Original Message -
From: Martin Mokrejs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 10:41 PM
Subject: Table crash!


 Don't do this when the table is in the cache!

 The correct way (open two xterms and do commands in this order):

 mysql flush tables;
 mysql lock table repository write;

 $ myisamchk -f -d -v repository.MYI # this will tell you the status of
 the table based on the index file


I've used myisamchk while mysql server was not running. I've shut it down
first and then tryed to fix it with myisamchk.

But I will try all those other options you have so kindly mentioned in your
reply. THNX! Will tell you about the results.

Regards,
Ale Perme



-
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

how can I use 'C' programs accessing a MySql

[ale]

The following form was submitted via MySQL.com feedback engine: 
  Name: Alexandre Adam
  E-mail address: [EMAIL PROTECTED]
  Company: sansoft informatica
  Position/Title: user
  Type of interest: for personal use
  State or province: SP
  Country: Brazil
  Support contract: no

  Enter Your Questions, Comments, Feedback or Your Message here:


I'm trying to understand how can I use 'C' programs accessing a MySql

DataBase, please, could you send me a small program or so that creates
a 
Table or two and make some changes on them. 
I read so many examples but all of them only contain parts of the
code.
please... help...what library I must include... 

Sincerely
Alexandre Adam
Sao Paulo - SP - BRAZIL

I wrote some code but nothing works... please read it below.

#include /usr/include/mysql/mysql.h
# include stream.h

int main () {  
{ Printf (Initializing...\n); }
if (mysql_create_db (mysql, DB_TEST)) {
fprintf (stderr, Failed to create DataBase, ERR!
%x\n, mysql_error( 
mysql));
}
return 0;
}
   

-
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