› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
meteor2013
V2EX  ›  MySQL

求能把 json 文件导入 MySQL 数据库的工具

  •  1
     
  •   meteor2013 · Aug 25, 2014 · 7479 views
    This topic created in 4467 days ago, the information mentioned may be changed or developed.
    9 replies  •  2014-08-25 15:31:33 +08:00
    Pandora78
    Pandora78
    Aug 25, 2014
    1
    https://github.com/danmandle/JSON2CSV
    然后: LOAD DATA INFILE 'filepath/your_csv_file.csv' INTO TABLE tablename;
    done.
    14
    14
    Aug 25, 2014
    2
    搭车讨论能把数据库导出到json的工具╮(╯▽╰)╭
    magine
    magine
    Aug 25, 2014
    3
    同问把数据库导出到json的工具
    withinthefog
    withinthefog
    Aug 25, 2014❤️2
    4
    @magine @14

    0XDBE:http://www.jetbrains.com/dbe/
    现在还在测试,要申请一下才能下载
    magine
    magine
    Aug 25, 2014
    5
    @withinthefog
    不喜欢用IDE,嗯,我只是矫情,不用管我orz
    withinthefog
    withinthefog
    Aug 25, 2014
    6
    @magine
    那么用nodejs/python/随便什么脚本写个导入工具吧...
    我之前就是这么干的
    magine
    magine
    Aug 25, 2014
    7
    @withinthefog
    嗯。
    hcymk2
    hcymk2
    Aug 25, 2014
    8
    @magine 这里有个ruby的轮子https://github.com/seamusabshere/mysql2xxxx
    不过好像有bug 指定端口号不能。
    lyragosa
    lyragosa
    Aug 25, 2014
    9
    我是直接把json存到一个格的……
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   4291 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 42ms · UTC 08:32 · PVG 16:32 · LAX 00:32 · JFK 03:32
    ♥ Do have faith in what you're doing.