if on unix/mac:
$ echo "select * from searchindex" | mysql -u wikiuser -p maqwiki
you can probably do something similar on windows..
On Wed, Sep 15, 2010 at 4:00 PM, Uwe Brauer <oub@stripped> wrote:
> I am still fighting with the crashed hard disk and its db.
> I had a look at the tables
> mysql -u wikiuser -p maqwiki
> 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
> 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:
> 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
- michael dykman
May the Source be with you.