Jump to content
Sign in to follow this  
Justin

CMD window closing, can't see error

Recommended Posts

Hi there, I'm writing a script to process some data files and import them into mySql community server. I'm doing this by having autoit create a .sql file containing my import commands, and then running a command line operation to tell mySql to import the files. The operation works fine when i open a cmd window and run it manually, but when the script runs it, the cmd window pops up, scrolls some text (looks like an error message and the help file to suggest some syntax) and closes before I can read what it says. Is there any way of keeping the cmd window open so that I can see the error message?

Here is the part of code that I'm using:

Run("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql", "C:\Program Files\MySQL\MySQL Server 5.0\bin\")

Share this post


Link to post
Share on other sites

Hi there, I'm writing a script to process some data files and import them into mySql community server. I'm doing this by having autoit create a .sql file containing my import commands, and then running a command line operation to tell mySql to import the files. The operation works fine when i open a cmd window and run it manually, but when the script runs it, the cmd window pops up, scrolls some text (looks like an error message and the help file to suggest some syntax) and closes before I can read what it says. Is there any way of keeping the cmd window open so that I can see the error message?

Here is the part of code that I'm using:

Run("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql", "C:\Program Files\MySQL\MySQL Server 5.0\bin\")
You could redirect the ouput to a file then read the file to see what the result was

Run("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql > output.log", "C:\Program Files\MySQL\MySQL Server 5.0\bin\")

Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script.

Share this post


Link to post
Share on other sites

@Justin or you can use "Stdout Read"...

From the helpfile..

; Demonstrates StdoutRead()
#include <Constants.au3>

$foo = Run(@ComSpec & " /c dir foo.bar", @SystemDir, @SW_HIDE, $STDERR_CHILD + $STDOUT_CHILD)

While 1
    $line = StdoutRead($foo)
    If @error Then ExitLoop
    MsgBox(0, "STDOUT read:", $line)
Wend

While 1
    $line = StderrRead($foo)
    If @error Then ExitLoop
    MsgBox(0, "STDERR read:", $line)
Wend

MsgBox(0, "Debug", "Exiting...")

Share this post


Link to post
Share on other sites

Ok, I used the STDOut command and pulled the output from the cmd window, and its just a listing of command line options. Why would it not be reading the options that i have in the script, which work when I manually type them, but not from the Run() command?

Here is the output:

STDOUT read: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql  Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
Copyright (C) 2002 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
  --auto-rehash    Enable automatic rehashing. One doesn't need to use
                      'rehash' to get table and field completion, but startup
                      and reconnecting may take a longer time. Disable with
                      --disable-auto-rehash.
  -A, --no-auto-rehash 
                      No automatic rehashing. One has to use 'rehash' to get
                      table and field completion. This gives a quicker start of
                      mysql and disables rehashing on reconnect. WARNING:
                      options deprecated; use --diSTDOUT read: sable-auto-rehash instead.
  -B, --batch        Don't use history file. Disable interactive behavior.
                      (Enables --silent)
  --character-sets-dir=name 
                      Directory where character sets are.
  --default-character-set=name 
                      Set the default character set.
  -C, --compress      Use compression in server/client protocol.
  -#, --debug[=#]    This is a non-debug version. Catch this and exit
  -D, --database=name Database to use.
  --delimiter=name  Delimiter to be used.
  -e, --execute=name  Execute command and quit. (Disables --force and history
                      file)
  -E, --vertical      Print the output of a query (rows) vertically.
  -f, --force        Continue even if we get an sql error.
  -G, --named-commands 
                      Enable named commands. Named commands mean this program's
                      internal commands; see mysql> help . When enabled, the
                      named commands can be used from any line of the query,
                      otherwise only from the first line, before an enter.
                      Disable with --disable-named-commands. This option is
                      disabled by default.
  -g, --no-named-commands 
                      Named commands are disabled. Use \* form only, or use
                      named commands only in the beginning of a line ending
                      with a semicolon (;) Since version 10.9 the client now
                      starts with this option ENABLED by default! Disable with
                      '-G'. Long format commands still work from the first
                      line. WARNING: option deprecated; use
                      --disable-named-commands instead.
  -i, --ignore-spaces Ignore space after function names.
  --local-infile      Enable/disable LOAD DATA LOCAL INFILE.
  -b, --no-beep    Turn off beep on error.
  -h, --host=name    Connect to host.
  -H, --html          Produce HTML output.
  -X, --xml        Produce XML output
  --line-numbers      Write line numbers for errors.
  -L, --skip-line-numbers 
                      Don't write line number for errors. WARNING: -L is
                      deprecated, use long version of this option instead.
  -n, --unbuffered  Flush buffer after each query.
  --column-names      Write column names in results.
  -N, --skip-column-names 
                      Don't write column names in results. WARNING: -N is
                      deprecated, use long version of this options instead.
  -O, --set-variable=name 
                      Change the value of a variable. Please note that this
                      option is deprecated; you can set variables directly with
                      --variable-name=value.
  --sigint-ignore    Ignore SIGINT (CTRL-C)
  -o, --one-database  Only update the default database. This is useful for
                      skipping updates to other database in the update log.
  -p, --password[=name] 
                      Password to use when connecting to server. If password is
                      not given it's asked from the tty.
  -W, --pipe          Use named pipes to connect to server.
  -P, --port=#      Port number to use for connection.
  --prompt=name    Set the mysql prompt to this value.
  --protocol=name    The protocol of connection (tcp,socket,pipe,memory).
  -q, --quick        Don't cache result, print it row by row. This may slow
                      down the server if the output is suspended. Doesn't use
                      history file.
  -r, --raw        Write fields without conversion. Used with --batch.
  --reconnect        Reconnect if the connection is lost. Disable with
                      --disable-reconnect. This option is enabled by default.
  -s, --silent      Be more silent. Print results with a tab as separator,
                      each row on new line.
  --shared-memory-base-name=name 
                      Base name of shared memory.
  -S, --socket=name   Socket file to use for connection.
  --ssl            Enable SSL forSTDOUT read:  connection (automatically enabled with
                      other flags). Disable with --skip-ssl.
  --ssl-ca=name    CA file in PEM format (check OpenSSL docs, implies
                      --ssl).
  --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl).
  --ssl-cert=name    X509 cert in PEM format (implies --ssl).
  --ssl-cipher=name   SSL cipher to use (implies --ssl).
  --ssl-key=name      X509 key in PEM format (implies --ssl).
  --ssl-verify-server-cert 
                      Verify server's "Common Name" in its cert against
                      hostname used when connecting. This option is disabled by
                      default.
  -t, --table        Output in table format.
  -T, --debug-info  Print some debug info at exit.
  --tee=name          Append everything into outfile. See interactive help (\h)
                      also. Does not work in batch mode. Disable with
                      --disable-tee. This option is disabled by default.
  --no-tee          Disable outfile. See interactive help (\h) also. WARNING:
                      option deprecated; use --disable-tee instead
  -u, --user=name    User for login if not current user.
  -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
  -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.
  -v, --verbose    Write more. (-v -v -v gives the table output format).
  -V, --version    Output version information and exit.
  -w, --wait          Wait and retry if connection is down.
  --connect_timeout=# Number of seconds before connection timeout.
  --max_allowed_packet=# 
                      Max packet length to send to, or receive from server
  --net_buffer_length=# 
                      Buffer for TCP/IP and socket communication
  --select_limit=#  Automatic limit for SELECT when using --safe-updates
  --max_join_size=#   Automatic limit for rows in a join when using
                      --safe-updates
  --secure-auth    Refuse client connecting to server if it uses old
                      (pre-4.1.1) protocol
  --show-warnings    Show warnings after every statement.

Default options are read from the following files in the given order:
C:\my.ini C:\my.cnf C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\Program Files\MySQL\MySQL Server 5.0\my.ini C:\Program Files\MySQL\MySQL Server 5.0\my.cnf 
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults    Print the program argument list and exit
--no-defaults       Don't read default options from any options file
--defaults-file=#   Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- -----------------------------
auto-rehash                    TRUE
character-sets-dir              (No default value)
default-character-set            latin1
compress                          FALSE
database                          (No default value)
delimiter                       ;
vertical                          FALSE
force                            FALSE
named-commands                  FALSE
local-infile                      FALSE
no-beep                        FALSE
host                              (No default value)
html                              FALSE
xml                            FALSE
line-numbers                      TRUE
unbuffered                      FALSE
column-names                      TRUE
sigint-ignore                    FALSE
port                              3306
prompt                          mysql> 
quick                            FALSE
raw                            FALSE
reconnect                        FALSE
shared-memory-base-name        (No default value)
socket                          (No default value)
ssl                            FALSE
ssl-ca                          (No default value)
ssl-capath                      (No default value)
ssl-cSTDOUT read: ert                         (No default value)
ssl-cipher                      (No default value)
ssl-key                        (No default value)
ssl-verify-server-cert          FALSE
table                            FALSE
debug-info                      FALSE
user                              root
safe-updates                      FALSE
i-am-a-dummy                      FALSE
connect_timeout                0
max_allowed_packet              16777216
net_buffer_length                16384
select_limit                      1000
max_join_size                    1000000
secure-auth                    FALSE
show-warnings                    FALSE

Share this post


Link to post
Share on other sites

Ok, I used the STDOut command and pulled the output from the cmd window, and its just a listing of command line options. Why would it not be reading the options that i have in the script, which work when I manually type them, but not from the Run() command?

Perhaps an issue with syntax being used which triggers the help index to be shown. When you run it manually, are you using the cmd prompt? If it runs manually then I am sure that Run() can do it. Any specific info that you can supply may help to solve your issue.

Here is something to try

#include <Constants.au3>

If FileChangeDir(@ProgramFilesDir & '\MySQL\MySQL Server 5.0\bin') Then
    $pid = Run(@ComSpec & ' /c mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql', '', @SW_HIDE, $STDERR_CHILD + $STDOUT_CHILD)
    $data = '--- StdOutRead ---' & @CRLF
    Do
        $data &= StdOutRead($pid)
    Until @error
    $data &= @CRLF & '--- StdErrRead ---' & @CRLF
    Do
        $data &= StdErrRead($pid)
    Until @error
    MsgBox(0, 'StdOutRead/StdErrRead', $data)
EndIf

:)

Share this post


Link to post
Share on other sites

Run('"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql"', "C:\Program Files\MySQL\MySQL Server 5.0\bin\"')

Or

$App = FileGetShortname("C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe")
Run($App & " -u root -p < d:\filemaker\sqltest\batch.sql")
Edited by GEOSoft

George

Question about decompiling code? Read the decompiling FAQ and don't bother posting the question in the forums.

Be sure to read and follow the forum rules. -AKA the AutoIt Reading and Comprehension Skills test.***

The PCRE (Regular Expression) ToolKit for AutoIT - (Updated Oct 20, 2011 ver:3.0.1.13) - Please update your current version before filing any bug reports. The installer now includes both 32 and 64 bit versions. No change in version number.

Visit my Blog .. currently not active but it will soon be resplendent with news and views. Also please remove any links you may have to my website. it is soon to be closed and replaced with something else.

"Old age and treachery will always overcome youth and skill!"

Share this post


Link to post
Share on other sites

#include <Constants.au3>

If FileChangeDir(@ProgramFilesDir & '\MySQL\MySQL Server 5.0\bin') Then
    $pid = Run(@ComSpec & ' /c mysql.exe -u root -p < d:\filemaker\sqltest\batch.sql', '', @SW_HIDE, $STDERR_CHILD + $STDOUT_CHILD)
    $data = '--- StdOutRead ---' & @CRLF
    Do
        $data &= StdOutRead($pid)
    Until @error
    $data &= @CRLF & '--- StdErrRead ---' & @CRLF
    Do
        $data &= StdErrRead($pid)
    Until @error
    MsgBox(0, 'StdOutRead/StdErrRead', $data)
EndIf
Thanks, this worked perfectly, but if anybody else is running into this problem, you have to change the syntax to:

$pid = Run(@ComSpec & ' /c mysql.exe -u root --password=passwordgoeshere < d:\filemaker\sqltest\batch.sql', '', @SW_SHOW, $STDERR_CHILD + $STDOUT_CHILD)

for it to login and run the script correctly.

Edited by Justin

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...