NAME

mysqlslurp - slurp <STDIN> into a MySQL table

SYNOPSIS

  mysqlslurp 
      -D | --database                   Database    
      --table                           Table
      [--tmp | --tmpdir | --temp ]      Temporary Directory

      [ --usage ]                       Prints this synopsis
      [ --man ]                         Prints full man page

      [options passed to mysqlimport] 
      ( see mysqlimport --help for a list of options )


  Example: 
    cat file | mysqlslurp --database=my_db --table=my_table

DESCRIPTION

mysqlslurp reads from <STDIN> and writes to directly to a MySQL table. Parameters --database and --table are required. Specifying a --tmp directory where the FIFO pipe will be created is optional. All other options are passed to mysqlimport unchanged.

ADVANTAGES

Speed

mysqlslurp wraps mysqlimport, the fastest way to import data into MySQL tables. Especially with the --use-threads option.

Data in Motion

Unlike mysqlimport, mysqlslurp does not require that the data be resident in a file on disk. This is handy in multiple server setups.

Good Defaults

Mostly just works.

SEE ALSO

MySQL::Slurp

mysqlimport at http://mysql.com, currently http://dev.mysql.com/doc/refman/5.1/en/mysqlimport.html

AUTHOR

Christopher Brown, <ctbrown@cpan.org<gt>

http://www.opendatagroup.com

COPYRIGHT AND LICENSE

Copyright (C) 2008 by Open Data

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.