List:General Discussion« Previous MessageNext Message »
From:Travis Ard Date:September 16 2010 12:38am
Subject:Re: extract text from table to file, and recover damage.
View as plain text  
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
>
> 
Thread
extract text from table to file, and recover damage.Uwe Brauer15 Sep
  • Re: extract text from table to file, and recover damage.Michael Dykman15 Sep
  • Re: extract text from table to file, and recover damage.Travis Ard16 Sep