NAME

mysql_to_db - convert a mysql table to fsdb format

SYNOPSIS

    mysql_to_db [options] SQL-command

DESCRIPTION

Execute the SQL command SQL-command and output the results in fsdb format.

Yes, this is a bit perverse.

Assumes it will talk to the Unix domain socket, not network.

My default, it converts NULL and all-space records to -.

OPTIONS

-U USER or <--user USER>

Specify the mysql user.

-P PASSWORD or <--password PASSWORD>

Specify the mysql password.

-D DATABASE or <--database DATABASE>

Specify the mysql database.

This module also supports the standard fsdb options:

-d

Enable debugging output.

-i or --input InputSource

Read from InputSource, typically a file name, or - for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

-o or --output OutputDestination

Write to OutputDestination, typically a file name, or - for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

--autorun or --noautorun

By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The --(no)autorun option controls that behavior within Perl.

--help

Show help.

--man

Show full manual.

SAMPLE USAGE

Input:

    xxx

Command:

    mysql_to_db  -U SENSYS2006 -P SENSYS2006 -D SENSYS2006 'show tables'

Output:

    xxx

SEE ALSO

Fsdb.

CLASS FUNCTIONS

new

    $filter = new Fsdb::Filter::mysql_to_db(@arguments);

Create a new mysql_to_db object, taking command-line arguments.

set_defaults

    $filter->set_defaults();

Internal: set up defaults.

parse_options

    $filter->parse_options(@ARGV);

Internal: parse command-line arguments.

setup

    $filter->setup();

Internal: setup, parse headers.

run

    $filter->run();

Internal: run over each rows.

AUTHOR and COPYRIGHT

Copyright (C) 1991-2008 by John Heidemann <johnh@isi.edu>

This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.

cpanm Fsdb

perl -MCPAN -e shell
install Fsdb