steveorevo/json2mysql

JSON2MySQL 是一款支持 PHP 序列化的 JSON 导入工具。

2.1.4 2022-05-17 18:11 UTC

This package is not auto-updated.

Last update: 2024-09-25 08:19:24 UTC


README

支持 PHP 序列化的 JSON 到数据库导入工具。

关于

此命令行工具将从配套工具 mysql2json 创建的指定 JSON 文件导入。对象将自动检测并以 PHP 序列化字符串存储。

帮助

输入 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