Trying to import a database to HeidiSQL

[delruth]

I am trying to learn this so I can avoid this since I have never dealt with it so please don't be rude.

Hello, So basically we are running a Dayz Overpoch Origins server, and we are trying to import a SQL from this 

 

 

It's the origins.sql in the files from that forum post, I posted there and on open dayz with no reply's in over a week. SO here is what is happening 

when i try to import the origins to my heidisql database i get http://i61.tinypic.com/egwg3o.jpg 

 

I was told to check line 20 in the origins.sql by a friend which I am guessing I need to re direct it to my data base but even when I re direct it to dayz_overpoch it still throws that error.

 

I will attatch the SQL file I am trying to import so you can all take a looksie. If it is a simple post or something I missed when reading the install and you see it please point it out, I am human I may have missed something.

 

If you could explain how to fix this so I can learn I would be greatly appreciative.

This is the origins SQL https://mega.co.nz/#!Phs1hDxC!v1EGFVXacugJi4_BdqjoFB7tF2m8a7IYLYeDVQw8090

 

 

Thanks for any help in advance.

[SideShowFreak]

Make sure the date in the objects being imported are after the database hasebeen created. This should fix it.

[delruth]

I'm not sure exactly what that mean's where do I find this?

[SideShowFreak]

Beach object you are trying to import has a date in its data. Change the dates for all the objects to a date after the database was created. Old data created before the database won't show up no matter how many times you try to add it. Away from home for the night so I can't access my database for an example to show you

[delruth]

I think I know what you are talking about, I found dates in the SQL and changed them to a different date, like yesterday I changed them to today but it still didn't work so i imagine im doing the wrong dates.

[SideShowFreak]

ok back at home lets see if i can help:

Lets say the import file looks like this on the top

 

INSERT INTO `object_data` (`ObjectID`, `ObjectUID`, `Instance`, `Classname`, `Datestamp`, `LastUpdated`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage`) VALUES

(21, 123456789101112, 24, 'SUV_Red', '2014-07-28 20:54:04', '2014-08-03 21:30:57', 0, '[93,[14735.4,13635.7,0.464]]', '[[[],[]],[["ItemBandage","ItemBriefcaseS60oz","CSGAS","ItemSodaRbull"],[2,1,4,1]],[[],[]]]', '[]', 0.94600, 0.00000),

(35, 75196111974037, 24, 'LandRover_MG_TK_EP1_DZE', '2014-07-28 20:54:09', '2014-08-18 19:16:58', 0, '[232,[8143.81,10651.2,0.007]]', '[[[],[]],[[],[]],[["DZ_Patrol_Pack_EP1"],[1]]]', '[["glass1",0.697],["motor",0.253],["palivo",0.42],["wheel_1_1_steering",0.452],["wheel_2_1_steering",0.385],["wheel_2_2_steering",0.397],["sklo predni P",0.252],["sklo predni L",0.367],["karoserie",0.408],["wheel_1_4_steering",0.238],["wheel_2_4_steering",0.701],["wheel_1_3_steering",0.304],["wheel_2_3_steering",0.591],["glass2",0.67],["glass3",0.61],["glass4",0.63]]', 0.96013, 0.00000),

 

 

Datestamp and Lastupdated both must be a date after the database was created

 

I highlighted the 2 spots in the lines above.  

[delruth]

I have attached the .SQL file on a meagaupload link in my first post, I just checked and I have no date stamps anywhere and mine looks completely different. I did change the database on line 20 to direct towards mine since its not from my database originally but the rest I am baffled on.

[SideShowFreak]

ok im seeing a better picture now of whats going on.  The error is stating that the setdamageonage script is already there, im assuming the other 6 errors are the same just for different categories?

 

 

After looking at the SQL file you are using  personally i would remove everything from line 1-75 and line 2459 till the end and try that.

That would remove the Events that are trying to be added.  Are you using Vilayer by chance?

[delruth]

Yep we use Vilayer. I am not sure what the other 6 errors are that error from the picture I linked is the only one I can see, I even tried just using the insert into traders_data section etc just to get the items in traders and it threw syntax errors. I am going to try deleting those lines you recommended and see what the result is.

[delruth]

Tried removing the lines, no go on that one. It said /* SQL Error (1062): Duplicate entry '1' for key 'PRIMARY' */