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:
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
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
PRIVILAGES should read PRIVILEGES
-Original Message-
From: Gary Roach [mailto:gary719_li...@verizon.net]
Sent: Wednesday 15 September 2010 19:11
To: mysql@lists.mysql.com
Subject: GRANT ALL error - newbee
I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first ti
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach wrote:
> I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
> first time. On my internal network (behind firewall) I have a computer
> (cruncher) that is acting as the web server. Another computer (supercrunch)
> is being used as t
I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first time. On my internal network (behind firewall) I have a computer
(cruncher) that is acting as the web server. Another computer
(supercrunch) is being used as the home for Dupal6. I connected to the
cruncher system fr
On Wed, Sep 15, 2010 at 3:39 PM, george larson wrote:
> I commonly set up a tunnel to the SSH server at the office and then
> another tunnel from that server to my development rig, so I can run
> MySQL WB at home on my database at work. Is that what you mean?
>
Pretty much, yeah. I've not got ju
Johan De Meersman wrote:
> On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent wrote:
>
>> You do know you can use ssh tunnels and such to connect to your server from
>> your desktop right? I do it all day long. It's pretty easy to do and built
>> in to these programs.
>>
>
> You can't multi-jump, t
On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent wrote:
> You do know you can use ssh tunnels and such to connect to your server from
> your desktop right? I do it all day long. It's pretty easy to do and built
> in to these programs.
>
You can't multi-jump, though. Yes, that's common in my envi
