Results 1 to 3 of 3

Thread: Month end Logs by email

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Default Month end Logs by email

    Hi All,

    I am hosting OR for a client.

    My client wants to receive logs every month end by email?

    Any help or hint ?

    Cheers,

    Kapil

  2. #2
    Join Date
    May 2004
    Location
    Long Island, NY
    Age
    49
    Posts
    9,796

    Default Re: Month end Logs by email

    Create a script to pull the info from the db and email it. Then run the script using a cron job.

  3. #3
    Join Date
    Feb 2009
    Posts
    2

    Default Re: Month end Logs by email

    I am not good at mysql.

    Tried the following command on cronjob in my cpanel which emails the output to my email.

    mysql -e --force --quick -uXUsernameX -pXPasswordX XDBX SELECT * FROM default_en_activitylog

    But it send a the following output to my email:
    mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1
    Copyright (C) 2000-2008 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: 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 --disable-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, --comments Preserve comments. Send comments to the server. The
    default is --skip-comments (discard comments), enable
    with --comments
    -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.
    --pager[=name] Pager to use to display results. If you don't supply an
    option the default pager is taken from your ENV variable
    PAGER. Valid pagers are less, more, cat [> filename],
    etc. See interactive help (\h) also. This option does not
    work in batch mode. Disable with --disable-pager. This
    option is disabled by default.
    --no-pager Disable pager and print to stdout. See interactive help
    (\h) also. WARNING: option deprecated; use
    --disable-pager instead.
    -p, --password[=name]
    Password to use when connecting to server. If password is
    not given it's asked from the tty.
    -P, --port=# Port number to use for connection or 0 for default to, in
    order of preference, my.cnf, $MYSQL_TCP_PORT,
    /etc/services, built-in default (3306).
    --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.
    -S, --socket=name Socket file to use for connection.
    -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:
    /etc/my.cnf ~/.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
    comments FALSE
    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 0
    prompt mysql>
    quick TRUE
    raw FALSE
    reconnect FALSE
    socket (No default value)
    table FALSE
    debug-info FALSE
    user kapilcha_orlt1
    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

Similar Threads

  1. 'most view this month' addon
    By budin24 in forum Addon help, ideas and discussion (CLOSED)
    Replies: 8
    Last Post: 06-20-2008, 12:55 PM
  2. Add per calender month (PCM) after price
    By tommo in forum Installation/Configuration Help (CLOSED)
    Replies: 3
    Last Post: 01-10-2008, 05:15 AM
  3. Server logs
    By skeeve in forum General Help (CLOSED)
    Replies: 1
    Last Post: 10-02-2006, 11:35 AM
  4. Deleting LOGS ???
    By ebmarques in forum General Help (CLOSED)
    Replies: 0
    Last Post: 07-19-2005, 08:48 AM
  5. Activity Logs
    By twcinnh in forum HELP (CLOSED)
    Replies: 3
    Last Post: 04-03-2005, 07:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •