extract text from table to file, and recover damage.

Hello

I am still fighting with the crashed hard disk and its db.

I had a look at the tables
mysql -u wikiuser -p maqwiki
and
then
select * from searchindex

(This is the only table which seems to have useful information.)
However the information is written so fast on the screen
that it is impossible to read, I also can scroll since a lot
of
---------------
Lines are produced.

- how can I write the result of the above command to
file? The obvious > does not work.

I think I see stuff like anu8c3a1lisis
which makes me thing the table is corrupted, of course it
could be also the UTF8 representation of the word análisis.

Anyhow I run a



mysqlcheck -u wikiuser -p maqwiki searchindex

And got:
maqwiki.searchindex OK


Is this proof enough that the table is ok?
Uwe Brauer


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: extract text from table to file, and recover damage.

if on unix/mac:
$ echo "select * from searchindex" | mysql -u wikiuser -p maqwiki
> myfile.txt

you can probably do something similar on windows..

On Wed, Sep 15, 2010 at 4:00 PM, Uwe Brauer wrote:
> Hello
>
> I am still fighting with the crashed hard disk and its db.
>
> I had a look at the tables
> mysql -u wikiuser -p maqwiki
> and
> then
> select * from searchindex
>
> (This is the only table which seems to have useful information.)
> However the information is written so fast on the screen
> that it is impossible to read, I also can scroll since a lot
> of
> ---------------
> Lines are produced.
>
> =A0 =A0- =A0how can I write the result of the above command to
> =A0 =A0 =A0 file? The obvious > does not work.
>
> I think I see stuff like anu8c3a1lisis
> which makes me thing the table is corrupted, of course it
> could be also the UTF8 representation of the word an=E1lisis.
>
> Anyhow I run a
>
>
>
> mysqlcheck -u wikiuser -p maqwiki searchindex
>
> And got:
> maqwiki.searchindex =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0OK
>
>
> Is this proof enough that the table is ok?
> Uwe Brauer
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: extract text from table to file, and recover damage.

You could try

SELECT ... INTO OUTFILE ...

Also, if you just want to look at the data a page at a time, try setting
your pager variable to your favorite pager program.

mysql> pager /usr/bin/less

and unset it with \n

mysql> \n

-Travis

--------------------------------------------------
From: "Uwe Brauer"
Sent: Wednesday, September 15, 2010 2:00 PM
To:
Subject: extract text from table to file, and recover damage.

> Hello
>
> I am still fighting with the crashed hard disk and its db.
>
> I had a look at the tables
> mysql -u wikiuser -p maqwiki
> and
> then
> select * from searchindex
>
> (This is the only table which seems to have useful information.)
> However the information is written so fast on the screen
> that it is impossible to read, I also can scroll since a lot
> of
> ---------------
> Lines are produced.
>
> - how can I write the result of the above command to
> file? The obvious > does not work.
>
> I think I see stuff like anu8c3a1lisis
> which makes me thing the table is corrupted, of course it
> could be also the UTF8 representation of the word análisis.
>
> Anyhow I run a
>
>
>
> mysqlcheck -u wikiuser -p maqwiki searchindex
>
> And got:
> maqwiki.searchindex OK
>
>
> Is this proof enough that the table is ok?
> Uwe Brauer
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=travis_ard@hotmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org