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" <o...@mat.ucm.es> Sent: Wednesday, September 15, 2010 2:00 PM To: <mysql@lists.mysql.com> 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/mysqlTo unsubscribe: http://lists.mysql.com/mysql?unsub=travis_...@hotmail.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
