no output in sql mode of GNU Emacs on WinXP

no output in sql mode of GNU Emacs on WinXP

[sparkw]

I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.

After I add the following line into the initialization file of emacs,


(setq sql-mysql-options '("-C" "-t" "-f" "-n"))

the output comes out, but the status line still doesn't show up. (e.g.
1
row in set (0.02 sec))

What's worse, I try to log the session with `\T logfile', but no
logfile
is generated. ( I check that with Google Desktop)

Thanks for your help.

Jieqi

Re: no output in sql mode of GNU Emacs on WinXP

[Koocyton]

;; set MySQL
(setq sql-mysql-program "d:/mysoft/mysql5/bin/mysql")
(setq sql-mysql-options '("-C" "-t" "-f" "-n" "--port=22222"))
;; truncate lines for long tables
(add-hook 'sql-interactive-mode-hook
    (function (lambda ()
         (setq truncate-lines t))))
(setq auto-mode-alist
      (append
       (list
        ;; insert entries for other modes here if needed.
        (cons "\.sq$" 'sql-mode))
       auto-mode-alist))
(add-hook 'sql-mode-hook 'font-lock-mode)

"sparkw" <jieqiwang@gmail.com> 
??????:1155369154.208955.98080@i42g2000cwa.googlegroups.com...
>I am using WinXP, GNU Emacs 23, MySQL 5.
> When I start a mysql process with `sql-mysql' in emacs, no output is
> displayed in the buffer until I quit or kill the process.
>
> After I add the following line into the initialization file of emacs,
>
>
> (setq sql-mysql-options '("-C" "-t" "-f" "-n"))
>
> the output comes out, but the status line still doesn't show up. (e.g.
> 1
> row in set (0.02 sec))
>
> What's worse, I try to log the session with `\T logfile', but no
> logfile
> is generated. ( I check that with Google Desktop)
>
> Thanks for your help.
>
> Jieqi
>
> 

Re: no output in sql mode of GNU Emacs on WinXP

[sparkw]

Koocyton wrote:
> ;; set MySQL
> (setq sql-mysql-program "d:/mysoft/mysql5/bin/mysql")
> (setq sql-mysql-options '("-C" "-t" "-f" "-n" "--port=22222"))

when I added "--port=22222", I can't connect to the local mysql server
which is using the default 3306 port. The erros message is

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
(10061)

Process SQL exited abnormally with code 1


> ;; truncate lines for long tables
> (add-hook 'sql-interactive-mode-hook
>     (function (lambda ()
>          (setq truncate-lines t))))
> (setq auto-mode-alist
>       (append
>        (list
>         ;; insert entries for other modes here if needed.
>         (cons "\.sq$" 'sql-mode))
>        auto-mode-alist))
> (add-hook 'sql-mode-hook 'font-lock-mode)
>
> "sparkw" <jieqiwang@gmail.com>
> ??????:1155369154.208955.98080@i42g2000cwa.googlegroups.com...
> >I am using WinXP, GNU Emacs 23, MySQL 5.
> > When I start a mysql process with `sql-mysql' in emacs, no output is
> > displayed in the buffer until I quit or kill the process.
> >
> > After I add the following line into the initialization file of emacs,
> >
> >
> > (setq sql-mysql-options '("-C" "-t" "-f" "-n"))
> >
> > the output comes out, but the status line still doesn't show up. (e.g.
> > 1
> > row in set (0.02 sec))
> >
> > What's worse, I try to log the session with `\T logfile', but no
> > logfile
> > is generated. ( I check that with Google Desktop)
> >
> > Thanks for your help.
> >
> > Jieqi
> >
> >