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" <oub@stripped>
Sent: Wednesday, September 15, 2010 2:00 PM
To: <mysql@stripped>
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=1
>
>
