NAME

ftndbadm - Administration of an SQL database for Fidonet/FTN processing.

VERSION

Version 0.13

DESCRIPTION

Administration of a database for Fidonet/FTN related processing. The SQL database engine is one for which a DBD module exists, defaulting to SQLite.

SYNOPSIS

ftndbadm [-t tablename] [-T db_type] [-D db_name] [-u db_user] [-p db_password] [-l log_file] [-v]

ftndbadm [-h | --help]

OPTIONS

-l

This would be the filename and path of a log file, with the default being ftnpldb.log in the current directory.

-x

Debug option.

-v

Verbose option.

-T

Database type. This needs to be a database type for which a DBD module exists, the type being the name as used in the DBD module. The default type is SQLite.

-D

Database name. For an SQLite databse; this needs to be at least the filename and can also include a path, and defaults to the file name ftndbttst.

-u

Database user. For an SQLite database, this defaults to an empty string as it does not need it.

-p

Database password. For an SQLite database, this defaults to an empty string as it does not need it.

-t

The nodelist table name to be used. Note that if there is a period in the name, that period will be changed to an underscore.

EXAMPLE

Given that $DBFILE is a file like /opt/ftndb/FTN-Database.db, the following command line can be used to create an FTN Nodelist table in that database file:

ftndbadm -T SQLite -D $DBFILE -t Nodelist -v

AUTHOR

Robert James Clay, <jame at rocasa.us>

BUGS

Please report any bugs or feature requests to bug-ftn-database at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=FTN-Database. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc ftndbadm

You can also look for information at:

SEE ALSO

L<FTN::Database>, L<FTN::Database::Nodelist>, L<listftndb>,
L<ftndbadm>, and L<nl2ftndb>

COPYRIGHT & LICENSE

Copyright 2010 Robert James Clay, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.