mysql2json

Database to JSON object conversion tool with support for PHP serialization.

About

This command line tool will export the specified database to a "pretty print" JSON object. Auto-detection of PHP serialized strings will also be converted to a JSON object. This tool allows for simple line-by-line representation of a MySQL database and is perfect for viewing content in text based comparison tools. Re-import can be performed using the companion tool, json2mysql.

Help

Type mysql2json --help

MySQL2JSON is a database to JSON export tool with support for serialized PHP.
Version 2.1.3

Usage: mysql2json [-x, --exclude] [-?, --help] [-h host, --hose host (default: localhost)] [-l, --list] [-o output, --output output] [-p password, --password password] [-P port, --port port] [-q, --quiet] [-t tables, --tables tables] [-u user, --user user (default: root)] [-v, --version] [database]

Optional Arguments:
        -?, --help
                print this help
        -h host, --hose host (default: localhost)
                host name or IP address (default: localhost)
        -l, --list
                list databases & tables available for export
        -x, --exclude
                excludes rows with _transient_ in option_name column (WordPress)
        -o output, --output output
                path & file (default is db name in current folder)
        -p password, --password password
                password to connect with (default is none)
        -P port, --port port
                the TCP/IP port number to connect to
        -t tables, --tables tables
                a comma delimited list of tables (default empty for all)
        -u user, --user user (default: root)
                username to connect as (default: root)
        -q, --quiet
                quiet (no output)
        -v, --version
                output version number
        database
                the database to export