郁闷

bobofreebird

今天恢复数据库是报错
load from cell_int_id.unl delimiter '$' insert into cell_int_id;
40386 row(s) loaded.  ---------------这个地方又成功导回


load from cell_int_id2.unl delimiter '$' insert into cell_int_id2;
0 row(s) loaded.


load from radio_cell_g_bak2.unl delimiter '$' insert into radio_cell_g_bak2;
  268: Unique constraint (informix.u1008_5526) violated.   100: ISAM error:  duplicate value for a record with unique key.
  847: Error in load file line 1.--------------------------这里失败
Error in line 908
Near character position 75

load from omc_h.unl delimiter '$' insert into omc_h;
  846: Number of values in load file is not equal to number of columns.

  847: Error in load file line 1..--------------------------这里失败

Error in line 909
Near character position 51

load from obj.unl delimiter '$' insert into obj;
16487 row(s) loaded.


load from switch_msc_copy331.unl delimiter '$' insert into switch_msc_copy331;
  268: Unique constraint (informix.u1032_560 violated.   100: ISAM error:  duplicate value for a record with unique key.
  847: Error in load file line 1..--------------------------这里失败

Error in line 911
Near character position 77

load from project_log.unl delimiter '$' insert into project_log;
0 row(s) loaded.
load from emergency.unl delimiter '$' insert into emergency;
  846: Number of values in load file is not equal to number of columns.

  847: Error in load file line 1...--------------------------这里失败

Error in line 898
Near character position 59
要么是违反约束，要么是数据格式问题,不知道那错了
  请各位大侠看看

bobofreebird

我把是想数据放到临时表中，然后insert到表中不会出错,

liaosnet

额........这些数据都有比较明显的提示错误~请自行检查..
对于字段不一致,请检查下你的数据里是不是有"$"这样的符号~

bobofreebird

关于恢复数据库的问题解决了,不过是另一种方式[  就是重新建一个库,然后在向新库中导入数据 ]


难道每次恢复的时候都要重新建一个新库?请大家看看