Christopher Brown > MySQL-Slurp > mysqlslurp

Download:
MySQL-Slurp-0.28.tar.gz

Annotate this POD

View/Report Bugs
Source  

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.

syntax highlighting: