我有一个mysql的dump文件,二进制的,内容如下。怎样吧它恢复到数据库中去?
-------------------------------------------------
mysqlbackupwithmysqldump                                                                            0100640 0000000 0000000 00000000073 10445435045 014703  0                                                                                                    ustar   root                            root                                                                                                                                                                                                                   Summary:DbSup:backup MYSQL
*:shared_partition: :/MDS/MYSQL
                                                                                                                                                                                                                                                                                                                                                                                                                                                                     MYSQL.partition.desc.secure_server.2                                                                0100644 0000000 0000000 00000000315 11741660225 016350  0                                                                                                    ustar   root                            root                                                                                                                                                                                                                   
ARCHIVE_NAME=MYSQL.partition
ARCHIVE_DEV=/dev/nfm/vol03
COMPRESS=yes
SNAPSHOT=no
HOSTNAME=secure_server
OBJECT_LIST='/MDS/MYSQL'
# Do not delete this lineLAST_BACKUP_DATE=12-04-2012
LAST_BACKUP_HOUR=19
                                                                                                                                                                                                                                                                                                                   MYSQL.partition.secure_server.2                                                                     0100644 0000000 0000000 02644434660 11741660071 015470  0                                                                                                    ustar   root                            root                                                                                                                                                                                                                   ?9`嘜 secure_server_MYSQL.partition@12-04-2012@19 靅雜鄱栵淄_笼凿幱姅l'鱊g*S挘閠{? J莛€喘 )壪辣赿v=砟纟噜拣$8??4~燒賬z紸嵇鷼蛜W针亃uy}}蠸U?鳤?烪?V?p%嶨N鍳鹻?{?毳腓┙拚`衝睑R郊:赺溅险緕}鶅襸iA趡?韀e晶鎃??调撢{貊-齇?戜煀贃浚?鬵d%制"锜姵耻G唞苅 鼆癇'^錙贠兎纸儯?謟o齢障uU1痞螂r6鹤?

解决方案 »

  1.   

     你是用什么工具DUMP出来的?
      

  2.   

    mysqldump出来的应该是文本的sql语句  不是二进制的  
      

  3.   

    客户给的数据,不知道是怎么导出的。说是dump文件。
    在网上搜索良久没找到怎么恢复这种二进制数据的方法。
    或者哪位知道这个是个什么文件?
      

  4.   

    mysql 的第三方备份工具太多了,弄成二进制的格式大多不同各不兼容,,,所以不知道用那个工具弄的备份
    如果弄成标准的SQL语句就没问题
    备份最好用官方的mysqldump,,
      

  5.   

    使用ndb_restore恢复
    http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-programs-ndb-restore.html
      

  6.   

    mysqldump恢复的文件是文本sql语句,不是二进制文件。