1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

MYSQL导入问题·

Discussion in '后端开发' started by oicq我爱玩, Jan 26, 2008.

  1. oicq我爱玩

    oicq我爱玩 New Member

    Joined:
    Jan 27, 2006
    Messages:
    5,205
    Likes Received:
    28
    (最大限制:8,192 KB)

    我的100多MB,怎么导入哦~?:lol:
     
  2. 摇摆

    摇摆 New Member

    Joined:
    Dec 19, 2007
    Messages:
    693
    Likes Received:
    0
  3. A君

    A君 Well-Known Member

    Joined:
    Aug 31, 2005
    Messages:
    19,987
    Likes Received:
    98
    帝国备份王
     
  4. oicq我爱玩

    oicq我爱玩 New Member

    Joined:
    Jan 27, 2006
    Messages:
    5,205
    Likes Received:
    28
    SQL 查询:

    -- phpMyAdmin SQL Dump
    -- version 2.11.2.2
    -- http://www.phpmyadmin.net
    --
    -- 主机: localhost
    -- 生成日期: 2008 年 01 月 26 日 17:36
    -- 服务器版本: 4.0.26
    -- PHP 版本: 4.4.7
    --
    -- 数据库: `a121922491810`
    --
    -- --------------------------------------------------------
    --
    -- 表的结构 `haizbbs_access`
    --
    CREATE TABLE IF NOT EXISTS `haizbbs_access` ( `uid` mediumint( 8 ) unsigned NOT NULL default '0',
    `fid` smallint( 6 ) unsigned NOT NULL default '0',
    `allowview` tinyint( 1 ) NOT NULL default '0',
    `allowpost` tinyint( 1 ) NOT NULL default '0',
    `allowreply` tinyint( 1 ) NOT NULL default '0',
    `allowgetattach` tinyint( 1 ) NOT NULL default '0',
    `allowpostattach` tinyint( 1 ) NOT NULL default '0',
    PRIMARY KEY ( `uid` , `fid` )
    ) TYPE = MYISAM ;


    MySQL 返回:[​IMG]
    #1046 - No database selected
     
  5. notnull

    notnull New Member

    Joined:
    Sep 27, 2005
    Messages:
    11,720
    Likes Received:
    37
    mysql -u root -p*** databasename<*.sql
     
  6. 小李

    小李 New Member

    Joined:
    Nov 3, 2005
    Messages:
    2,468
    Likes Received:
    20
    帝国备份王 用了都说好
     
  7. oicq我爱玩

    oicq我爱玩 New Member

    Joined:
    Jan 27, 2006
    Messages:
    5,205
    Likes Received:
    28
    我一直在用,的确很不错。。。嘎嘎·
     
  8. laogui

    laogui Administrator
    Staff Member

    Joined:
    Aug 30, 2005
    Messages:
    15,216
    Likes Received:
    35
    用命令飞快
    mysql> use testdb;
    mysql> source testdb.sql;
     
  9. Kevin

    Kevin New Member

    Joined:
    Oct 23, 2005
    Messages:
    12,728
    Likes Received:
    55
    我习惯把sql切成几个来操作~~
     
  10. 八匹肥狼

    八匹肥狼 New Member

    Joined:
    Oct 28, 2007
    Messages:
    1,867
    Likes Received:
    0
    备份的时候就分块....一般的建站程序都有这功能了~

    其他不会,,,,哇卡卡,还有就是人手导入~