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 causing the problem but I
think when the "overhead" reaches a limit - it dumps data in the row or
table. I can't say for sure- but I think "overhead" had something to do with
it. I'm still looking for a workaround.
In the meantime - a back-up is smart
Mark
-----Original Message-----
From: Scott Wang <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, January 29, 2002 10:35 AM
Subject: Lost Data #2
>
>{ Am I to assume there is no solution to my problem? }
>
>Greetings,
>
>I have two large tables in a database with a few million entries. There is
only one column in each table.
>
>Everything was working okay until today. The size of the table files is
1gb+ but PHPMyAdmin says it has no records.
>
>When I try to export 200,000 of the contents to a text file:
>
>mysql> select * from tbl_name limit 0,200000 into outfile
"outfilename.txt";
>
>It takes a couple minutes of processing but the resulting file is still 0k
in size. PHPMyAdmin still says 0 records. But the table files are huge -
800mb to 1gb.
>
>Before I noticed this, I transferred the tables to another computer with
MySQL installed. It took a long time to transfer so I know the file really
was huge. But now on both computers the results are the same - no records.
>
>I ran:
>
>mysql>check table tbl_name;
>
>and it says that it's fine.
>
>mysql>restore table tbl_name;
>
>Only takes the 1gb table files and turns them into 10k files, still no
records.
>
>Thankfully I have a backup on the other computer now that the table files
are 10k. The other computer still has the 1gb files.
>
>Is there any way to restore this data??? This happened suddenly with two
different tables, at the same time. They were the two largest tables in the
database - other unaffected tables are smaller.
>
>Thank you,
>
>- Scott Wang
>[EMAIL PROTECTED]
>http://www.scottscomputing.com
>
>
>---------------------------------------------------------------------
>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
>
---------------------------------------------------------------------
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
