Toools
V2EX  ›  问与答

只有一个数据库为 gt_ipdata.sql 文件 如何转换成 gt_ipdata.MYD gt_ipdata.frm gt_ipdata.myi

  •  
  •   Toools · Nov 10, 2015 · 2342 views
    This topic created in 3883 days ago, the information mentioned may be changed or developed.

    下载地址 http://7fv8ve.com1.z0.glb.clouddn.com/ip.sql

    数据库是 mysql 开启了 InnoDB

    里面大概类容是

    insert into gt_ipdata(startip,endip,area) values('010.000.000.000','010.003.050.255','北京');
    insert into gt_ipdata(startip,endip,area) values('010.011.000.000','010.013.255.255','天津');
    insert into gt_ipdata(startip,endip,area) values('010.017.000.000','010.022.255.255','河北');
    insert into gt_ipdata(startip,endip,area) values('010.023.000.000','010.028.255.255','山西');
    insert into gt_ipdata(startip,endip,area) values('010.029.000.000','010.033.255.255','内蒙古');
    insert into gt_ipdata(startip,endip,area) values('010.034.000.000','010.041.255.255','辽宁');
    insert into gt_ipdata(startip,endip,area) values('010.042.000.000','010.047.255.255','吉林');
    insert into gt_ipdata(startip,endip,area) values('010.048.000.000','010.051.255.255','黑龙江');
    insert into gt_ipdata(startip,endip,area) values('010.052.000.000','010.061.255.255','湖北');
    insert into gt_ipdata(startip,endip,area) values('010.062.000.000','010.067.255.255','湖南');
    insert into gt_ipdata(startip,endip,area) values('010.068.000.000','010.073.255.255','河南');

    问题来了
    如何把 sql 文件转换为

    gt_ipdata.MYD
    gt_ipdata.frm
    gt_ipdata.myi
    这三个原始的格式
    求大神指点或者直接帮 转换一下 谢谢

    1 replies    2015-11-10 14:26:09 +08:00
    iscraft
        1
    iscraft  
       Nov 10, 2015
    改引擎不行么
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2716 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 33ms · UTC 11:42 · PVG 19:42 · LAX 04:42 · JFK 07:42
    ♥ Do have faith in what you're doing.