Help migrating a dayz.st database

[Sp00neY]

Hi all,

 

I need some help migrating an Epoch database from DayZ.st

It seems they use a different hive to the one Epoch uses as default.

I have tried exporting the database as an sql file and importing it

into the new database but things are really messed up, (ie bases

are only half there, if there at all, and same with vehicles)

 

Any help that can be given with this problem would be fantastic

as we really need to move this server to its new location quite soon.

 

I have root access to the new server (as its on my dedicated box),

and would love some help with this.

 

 

Thanks in advance

 

Sp00neY

[sm1l3r]

Hi,

 

Sorry not to be a great help but i have a new server and have tried to export the DB from Dayz.st and it doesnt work half the bases have all disappeared. All you need to do is get two IE pages or browsers open one with your Dayz.st DB on and the other with your new db on. Delete your old DB i did this by dropping everything in phpmyadmin 

 

Export your Dayz,st to a sql file then simply import that file back in on ur new phpmyadmin 

 

should work my DB went back but stuff was missing like i said.

 

cheers

 

Smiler

[BLFonsworth]

Unless you know how to reconfigure the server files to use the DB correctly, You're stuck. I had the same issue. Dayz.st does things different

[TheVampire]

If you export the MYSQL its simple enough to change them into new MySQL queries, but you wont be able to simply import it. You need to extract the queries and run them manually against your database.

 

If you PM me your SQL Export I can help you with it.

[Kivuli]

You actually CAN import the dump file but you'll need to change a few things after you execute it. ViLayer uses all lowercase for the table names. I don't know if Epoch cares about that but I changed it just to be sure. Then there's a few specific things you have to do after you import the data to make it work.

 

In character_data:

 

1. Update the InstanceID field to reflect your new instance. 11 for Chernarus, 16 for Panthera, etc.

 

In object_data:

 

1. Update the Instance field to reflect your new instance.

2. Update your Timestamp field to something after the server was first set up. I just used midnight on the day I figured it out.

3. Update your LastUpdated field to be something after the server was first set up. Easiest to just use the same date as Timestamp.

 

After I did that, all my objects were there and properly placed in the new server.

 

To update instance ID you can use this query (replace the ## with your instance):

UPDATE character_data SET InstanceID = ##;
UPDATE object_data SET Instance = ##;

To update the Timestamp and LastUpdated you can use something similar:

UPDATE object_data SET Timestamp = '2014-02-24 00:00:00';
UPDATE object_data SET LastUpdated = '2014-02-24 00:00:00';

Doing this (after much hair pulling) worked a treat.

[Just_R]

I exported a friend's dayz.st database and have apache running on my computer and phpmyadmin pulled in the exported file fine.  

 

NOW I haven't attempted to port this into a working server since I have a test server not related to my friend's but . . . 

 

all the data seems to be there and intact.

 

Hi all,

 

I need some help migrating an Epoch database from DayZ.st

It seems they use a different hive to the one Epoch uses as default.

I have tried exporting the database as an sql file and importing it

into the new database but things are really messed up, (ie bases

are only half there, if there at all, and same with vehicles)

 

Any help that can be given with this problem would be fantastic

as we really need to move this server to its new location quite soon.

 

I have root access to the new server (as its on my dedicated box),

and would love some help with this.

 

 

Thanks in advance

 

Sp00neY

[cman]

You actually CAN import the dump file but you'll need to change a few things after you execute it. ViLayer uses all lowercase for the table names. I don't know if Epoch cares about that but I changed it just to be sure. Then there's a few specific things you have to do after you import the data to make it work.

 

In character_data:

 

1. Update the InstanceID field to reflect your new instance. 11 for Chernarus, 16 for Panthera, etc.

 

In object_data:

 

1. Update the Instance field to reflect your new instance.

2. Update your Timestamp field to something after the server was first set up. I just used midnight on the day I figured it out.

3. Update your LastUpdated field to be something after the server was first set up. Easiest to just use the same date as Timestamp.

 

After I did that, all my objects were there and properly placed in the new server.

 

To update instance ID you can use this query (replace the ## with your instance):

UPDATE character_data SET InstanceID = ##;
UPDATE object_data SET Instance = ##;

To update the Timestamp and LastUpdated you can use something similar:

UPDATE object_data SET Timestamp = '2014-02-24 00:00:00';
UPDATE object_data SET LastUpdated = '2014-02-24 00:00:00';

Doing this (after much hair pulling) worked a treat.

I did all of that and it seemed to only transfer all of the vehicles and safes, but for some reason it only transferred partial bases. It seems like the newest base additions are the ones that are transferring, all the old bases are gone. Even though all of the Datestamp and Lastupdated are all set the same. Any help would be great.