NAME

narada-mysqldump - dump project database

VERSION

This document describes narada-mysqldump version 1.3.10

USAGE

    narada-mysqldump

DESCRIPTION

Backup your Narada project's MySQL database.

If "config/db/db" absent or empty do nothing.

Dump database as quickly as possible to files "var/sql/*.sql":

• Tables listed in "config/db/dump/ignore" doesn't included in dump (even in database scheme).
• Database scheme saved in "var/sql/db.scheme.sql".
• Content for tables listed in "config/db/dump/empty" doesn't dumped.
• Content for tables listed in "config/db/dump/incremental" saved in "var/sql/TABLE_NAME.FROM-TO.sql".
  • Only new rows will be saved, which is absent in already existing files.
• Content for other tables saved in "var/sql/TABLE_NAME.sql".
  • If table wasn't changed since previous dump - do nothing and just keep file with previous dump.
• All other "*.sql" files will be removed from "var/sql/".

To force full dump (including incremental and unchanged tables) run "rm var/sql/*.sql" before "narada-mysqldump".

Will set exclusive lock on this project while doing database analyse and dumping database scheme and non-incremental tables. Incremental tables will be dumped after releasing lock.

Will set dump file's mtime to Update_time of related database table, and use mtime on next dump to detect table change.

All incremental tables MUST have first column's type "INT AUTO_INCREMENT PRIMARY KEY" (can also use "MEDIUMINT", etc.).

After ALTERing incremental table or doing TRUNCATE existing files with incremental dumps will be automatically removed and replaced by new ones.

Tables listed in "config/db/dump/empty" and "config/db/dump/incremental" must exists; listed in "config/db/dump/ignore" may not exists.

Script must be executed only from "project root directory".

REQUIRED ARGUMENTS

None.

OPTIONS

See USAGE.

DIAGNOSTICS

Usage: narada-mysqldump

Script was executed with too many params.

CONFIGURATION AND ENVIRONMENT

narada-mysqldump use these configuration files:

    config/db/db
    config/db/login
    config/db/pass
    config/db/host
    config/db/port
    config/db/dump/incremental
    config/db/dump/empty
    config/db/dump/ignore

DEPENDENCIES

None.

INCOMPATIBILITIES

None reported.

BUGS AND LIMITATIONS

No bugs have been reported.

Please report any bugs or feature requests to bug-narada@rt.cpan.org, or through the web interface at http://rt.cpan.org.

AUTHOR

Alex Efros <powerman@cpan.org>

LICENSE AND COPYRIGHT

Copyright (c) 2008-2014 Alex Efros <powerman@cpan.org>. All rights reserved.

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

DISCLAIMER OF WARRANTY

BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE SOFTWARE, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE SOFTWARE "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR, OR CORRECTION.

IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE SOFTWARE AS PERMITTED BY THE ABOVE LICENCE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.