This Skript is meant to ease the web development process using local repositories by automatically creating database backups and migrating databases from local to remote hosts and vice versa.
./adt.phps [options]
./adt.phps [options] <command> [command_options] [args]
-v, --verbose |
turn on verbose output |
--debug |
turn on debug output |
-h, --help |
show help and exit, also available for sub-commands |
--version |
show version and exit |
dump: Create a gzipped database dump- o, --output <file>: Specify output file
import <file>: Import SQL into a databaselocalize: Replace every occurence of the remote host with the local host.-o <file>, --output <file>: Specify output file
remotize: Replace every occurence of the local host with the remote host.-o <file>, --output <file>: Specify output file
replace: Replace every occurence of a pattern with a replacement.-o <file>, --output <file>: Specify output file-s, --serialize: Whether the pattern is enclosed in a serialized string that should be properly modified
adt -v dump |
Create a database dump and output verbose information |
adt import ./dump.sql |
Import './dump.sql' into the database |
adt localize -h |
Get help on the 'localize'-Command |
adt replace -s -o out.sql |
Replace a serialized string and save to out.sql. |
Composer (https://getcomposer.org/)
Composer packages:
pear2/console_commandline (https://packagist.org/packages/pear2/console_commandline)
Install composer in the adt folder like this:
- run this curl:
curl -sS https://getcomposer.org/installer | php
- run composer:
php composer.phar install
The wordpress directory contains a sample wp_config.php that can be used for testing. Should be modified to point to a valid wordpress database setup.
Sync your wordpress assets like this: rsync -avun --size-only --rsh="ssh -p PORT" --delete user@host:remote/path/to/wp-content/uploads/ local/path/to/wp-content/uploads/. This will download and update your local files depending on their remote state. Missing remote files are deleted locally.