Hello.
On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote:
> Hello:
>
> I was trying isamchk on my tables. Found one table with deleted blocks.
You know, there would be no reason to repair, except to reclaim the
disk space of the deleted rows?
> Used this opt
Hi,
Many Thanks. I couldn't find out the isamchk utility on our server. I tried
Telnet'ing to the server and typing the command. Its showing command not
found. Could you please send me more details of this utility.
Regards
At 06:47 PM 5/16/02 +0200, you wrote:
>Hi.
>
&
Hi.
Well, what's the problem with using isamchk in detail?
Shut down the mysql daemon, run "isamchk" on all tables to find out
which are corrupted and run "isamchk -r" on those. Then restart
mysqld. Do not forget to make backup copies of the tables in question
bef
Hello:
Can anybody help me out to repair my database & tables using ISAMCHK
utility. The MySQL server version is 3.21.33b installed on BSD server.
Many thanks
Sheni
Details of the problem that we are facing now:
We are facing a serious problem with the MySQL server installed on our
I have an incorrect key file which mySQL politely suggests I should
repair. However, when I call isamchk I always get the message
isamchk: error: 22 when opening ISAM-table ''
on this particular computer (RedHat 7.1 with mySQL 3.23.33), no
matter which db I try to inspect or re
I have an incorrect key file with mySQL politely suggesting I should
repair it. However, when I call isamchk I always get the message
isamchk: error: 22 when opening ISAM-table ''
on this particular computer (RedHat 7.1), no matter which db I try to
inspect or repair. If I move th
> I was running myisamchk and ismchk on my databases and I got the
> following error:
>
> "warning: 1 clients is using or hasn't closed the table properly"
You aren't running (my)isamchk with mysqld running are you? If so, you
shouldn't be.. or at least
hi,
I was running myisamchk and ismchk on my databases and I got the following
error:
"warning: 1 clients is using or hasn't closed the table properly"
what does this mean ?
how to prevent it ?
Who can help me out ?`
kind regards
Koen Gogne
[EMAIL PROTECTED]
--
The idea is to have backups.
Backups of unchecked data are not useless.
Backups of truncated data files are.
People have lost data when the disk became full during isamchk, or the
index had been crashed because it reached filesystem size limits.
If you blow the data away with a failed [my
If you back them up before you check them, and the check blows up, you
still have your backups.
Koen Gogne wrote:
> hi,
>
> I'm trying to automate the back up of my MySQL databases,
> and before I perform my backup I check my tables using
> myisamchk and isamchk.
> Whe
hi,
I'm trying to automate the back up of my MySQL databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong
hi,
I'm trying to automate the back up of my MySQL databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when ru
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when ru
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when ru
Never run isamchk with the server running.
Joan Vidal wrote:
> I can't believe MySQL is behaviouring that way and giving that kind of errors.
> I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
> all with the same results.
>
> Can anyone
o insert 2 registers,
* to erase 1 register,
* and... in this point of it annoys everything.
TO PASS a ISAMCHK with option - r (to repair).
Once I throw this, the table is in a error state.
When I passed a SELECT count(*) gives 1 registry us,
and if we happened a SELECT * says that this vacia t
I just compiled MySQL 3.22.27 (yes, I know it's an old package)
under RedHat 7.0. It compiles and installs fine and mysqld seems
to run ok, but isamchk refuses to check tables:
isamchk: error: 22 when opening ISAM-table 'note.ISM'
The file exists and is readable by root:
-rw-r
Hello,
Several of my tables are corrupted. I have a Win system.
How can I repair my DB's with isamchk. What would I have to enter to the command
line if I would like to check all DB's and all tables? The help says that I have
to specify the table on the command line - it gives the e
> "jds" == j d stumbles <[EMAIL PROTECTED]> writes:
jds> I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
jds> updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
jds> or UPDATE statements.
I've never had table corruption on a Solaris box, even
3 times in the last few days I've had tables that have become
corrupted and needed isamchk -r to repair them. I'm becoming concerned:
what can cause such errors? (and what can I do to avoid them?)
I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have process
i am trying to run isamchk / myisamchk on some table files in my database. the tables
are read just fine from the mysql terminal
and the ANALYZE TABLE query returns no errors, yet the isamchk / myisamchk say"error:
22 when opening ISAM-table ... "
the file name is correct ( i ge
Hello
> I assume simply doing a check is a read only operation so how is
> this possible if the data file is not changing?
The manual says: "in some case CHECK TABLE will change the table!
This happens if the table is marked as 'corrupted' or 'not closed
properly' but CHECK TABLE didn't find an
I have had the following problem with both mysql 3.22 (using isamchk) and
3.23 (using myisamchk).
I use either isamchk table.ISM or isamchk -e table.ISM. The utility reports
a miscellaneous error (error: Record at: 20224201 Can't find key for
index: 2 for example).
I run the check
"Gerald L. Clark" wrote:
>
> Stuart Fox wrote:
> >
> > Hi
> >
> > Can anybody tell me what this error means
> >
> > user@server#isamckh -av {database}/*.ISM
> >
> > isamchk: error: 22 when opening ISAM-table '{database}/tax.I
Stuart Fox wrote:
>
> Hi
>
> Can anybody tell me what this error means
>
> user@server#isamckh -av {database}/*.ISM
>
> isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
> tables)
>
If this was part of a script, then database was a
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
System is RedHat 7.0 i386 SMP Standard Kernel
mysql-3.22.32 standard compile from source --prefix=/usr/local
Ive
27 matches
Mail list logo