Hello, I currently have a overpoch server on GTX. For certain reason's (a whole other post), if am moving over to vilayer. I have the server setup the way I want it, however I am having problems moving the database. I open HeidiSQL and right click my GTX overpoch database then click on export database as SQL. I save that to my desktop, I then login to my vilayer database using heidiSQL. I click on dayz_overpoch database which already has object_data, player_data etc in it. With that highlighted I go to file load SQL file, and select the saved database from GTX. I then click the blue run button on the top toolbar. I get a popup error saying
"Your query produced 23 warnings.
Warning from your last query:
Note: the user specified as a definer
('overpoch12897'@'%') does not exist"
I do not know where to look for the errors. Any help would be great.
Edited to add
I tried the free trail of navicat, It looks like I can transfer most of the stuff over with that. However part of the object data does not come. Example one of my base's the the few other base's near it are gone, some of the vehicles are there. I go to my other base the bottom part (wood walls) are there and some of the walkways are there but the upper part that is cinder is gone. I have a vector built cinder garage door that is still there. I built it a few days ago.
Question
Mike85
Hello, I currently have a overpoch server on GTX. For certain reason's (a whole other post), if am moving over to vilayer. I have the server setup the way I want it, however I am having problems moving the database. I open HeidiSQL and right click my GTX overpoch database then click on export database as SQL. I save that to my desktop, I then login to my vilayer database using heidiSQL. I click on dayz_overpoch database which already has object_data, player_data etc in it. With that highlighted I go to file load SQL file, and select the saved database from GTX. I then click the blue run button on the top toolbar. I get a popup error saying
"Your query produced 23 warnings.
Warning from your last query:
Note: the user specified as a definer
('overpoch12897'@'%') does not exist"
I do not know where to look for the errors. Any help would be great.
Edited to add
I tried the free trail of navicat, It looks like I can transfer most of the stuff over with that. However part of the object data does not come. Example one of my base's the the few other base's near it are gone, some of the vehicles are there. I go to my other base the bottom part (wood walls) are there and some of the walkways are there but the upper part that is cinder is gone. I have a vector built cinder garage door that is still there. I built it a few days ago.
Edited by Mike85Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now