mysqlslurp - slurp <STDIN> into a MySQL table
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
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.
mysqlslurp wraps mysqlimport, the fastest way to import data into MySQL tables. Especially with the --use-threads option.
Unlike mysqlimport, mysqlslurp does not require that the data be resident in a file on disk. This is handy in multiple server setups.
Mostly just works.
mysqlimport at http://mysql.com, currently http://dev.mysql.com/doc/refman/5.1/en/mysqlimport.html
Christopher Brown, <ctbrown@cpan.org<gt>
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.
