steveorevo/json2mysql

JSON2MySQL is a JSON import tool with support for PHP serialization.

2.1.4 2022-05-17 18:11 UTC

Requires

• league/climate: ^3.4
• steveorevo/gstring: ^1.1

MIT

• Stephen J. Carnam

README

JSON to database import tool with support for PHP serialization.

About

This command line tool will import the specified JSON file created from the companion tool mysql2json. Auto-detection of objects will be stored as PHP serialized strings.

Help

Type json2mysql --help

JSON2MySQL is a JSON import tool with support for PHP serialization.
Version 2.1.4

Usage: json2mysql [-d dbname, --dbname dbname] [-?, --help] [-h host, --host host (default: localhost)] [-l, --list] [-p password, --password password] [-P port, --port port] [-q, --quiet] [-s, --skip] [-t tables, --tables tables] [-u user, --user user (default: root)] [-v, --version] [json_file]

Optional Arguments:
        -?, --help
                print this help
        -h host, --host host (default: localhost)
                host name or IP address (default: localhost)
        -l, --list
                list tables available for import
        -p password, --password password
                password to connect with (default is none)
        -P port, --port port
                the TCP/IP port number to connect to
        -s, --skip
                skip dropping/creating of existing database
        -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 and default question to yes)
        -v, --version
                output version number
        -d dbname, --dbname dbname
                override, create/import using specified database name
        json_file
                the json file to import