Hey there, I'm moving my server from one host to another but I'm having problems transfering instance_vehicle and so forth over to the new server. I have successfully added profile, survivor but my old server has many extra vehicles and people with bases.
I would like to keep that intact if possible. Thanks for your help!
and then when I truncate instance_vehicle and try to import my table I get this:
I would like to keep that intact if possible. Thanks for your help!
Code:
SQL query:
-- -- Dumping data for table `instance_vehicle` -- INSERT INTO `instance_vehicle` (`id`, `world_vehicle_id`, `instance_id`, `worldspace`, `inventory`, `parts`, `fuel`, `damage`, `last_updated`, `created`) VALUES (3, 9, 340, '[160,[3577.77,5309.97,0.002]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.232],["palivo",0.799],["wheel_1_1_steering",0.48],["wheel_1_2_steering",0.232],["wheel_2_1_steering",0.48],["wheel_2_2_steering",0.229],["karoserie",0.232]]', 0, 0.26377999782562256, '2013-01-05 20:34:20', '2012-12-27 01:20:51'), (7, 15, 340, '[324,[8295.54,5133.54,-1.831e-04]]', '[[[],[]],[["2Rnd_shotgun_74Pellets","2Rnd_shotgun_74Slug"],[1,1]],[[],[]]]', '[["motor",0.169],["karoserie",0.169],["palivo",0.165],["wheel_1_1_steering",0.888],["wheel_2_1_steering",0.626],["wheel_1_2_steering",0.242],["wheel_2_2_steering",0.165],["glass1",1],["glass2",1],["glass3",0.426],["glass4",0.165]]', 0, 0.17716500163078308, '2013-01-06 22:16:43', '2012-12-27 01:20:51'), (9, 20, 340, '[261,[9909.06,7085.3[...]
MySQL said:
#1062 - Duplicate entry '3' for key 'PRIMARY'and then when I truncate instance_vehicle and try to import my table I get this:
Code:
SQL query:
-- -- Dumping data for table `instance_vehicle` -- INSERT INTO `instance_vehicle` (`id`, `world_vehicle_id`, `instance_id`, `worldspace`, `inventory`, `parts`, `fuel`, `damage`, `last_updated`, `created`) VALUES (3, 9, 340, '[160,[3577.77,5309.97,0.002]]', '[[[],[]],[[],[]],[[],[]]]', '[["motor",0.232],["palivo",0.799],["wheel_1_1_steering",0.48],["wheel_1_2_steering",0.232],["wheel_2_1_steering",0.48],["wheel_2_2_steering",0.229],["karoserie",0.232]]', 0, 0.26377999782562256, '2013-01-05 20:34:20', '2012-12-27 01:20:51'), (7, 15, 340, '[324,[8295.54,5133.54,-1.831e-04]]', '[[[],[]],[["2Rnd_shotgun_74Pellets","2Rnd_shotgun_74Slug"],[1,1]],[[],[]]]', '[["motor",0.169],["karoserie",0.169],["palivo",0.165],["wheel_1_1_steering",0.888],["wheel_2_1_steering",0.626],["wheel_1_2_steering",0.242],["wheel_2_2_steering",0.165],["glass1",1],["glass2",1],["glass3",0.426],["glass4",0.165]]', 0, 0.17716500163078308, '2013-01-06 22:16:43', '2012-12-27 01:20:51'), (9, 20, 340, '[261,[9909.06,7085.3[...]
MySQL said:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`user-340`.`instance_vehicle`, CONSTRAINT `instance_vehicle_ibfk_1` FOREIGN KEY (`instance_id`) REFERENCES `instance` (`id`))