Hello.
I've run a safe recover on a table after I had to recreate the index file:
If you had to recreate the index file after upgrading, this could be a
character set issue. I mean that data is ok, but you see it after converting
to another character set. myisamchk in this case doesn't
Just reposting in case anyone missed it! Or have I asked a dumb question?!
Hi,
I've run a safe recover on a table after I had to recreate the index file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe-recover internet_usage
- recovering (with keycache) MyISAM-table 'internet_usage'
Data records:
PROTECTED]
Sent: Tuesday, 18 January 2005 6:32 AM
To: mysql@lists.mysql.com
Subject: RE: lost data
Just reposting in case anyone missed it! Or have I asked a dumb
question?!
Hi,
I've run a safe recover on a table after I had to recreate the index
file:
# myisamchk --tmpdir=/proxydb/mysql/tmp --safe
Scott -
I recently had a similar problem with a JSP application I built using MySQL
on the backend.
Don't know what the issue is/was but I did notice that if I was updating
rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of
overhead in the table. I'm not sure what is
To get rid of overhead, run an OPTIMIZE TABLE on the table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:02 AM
To: Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data
, January 29, 2002 4:18 PM
Subject: RE: Lost Data #2
To get rid of overhead, run an OPTIMIZE TABLE on the table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:02 AM
29, 2002 5:45 PM
To: Matthew Walker; Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data #2
If I run optimize on the table once - will I have to come back and so it
again?
If so - how often?
Thanks
Mark
-Original Message-
From: Matthew Walker [EMAIL PROTECTED]
To: Mark Stringham [EMAIL