Importing a DB from one server to another server - using php my admin

M

Megaz

Member
Hi Guys, My Php skills is somewhat lacking, Im trying to import the DB from my live server to a test server that I have running on my main computer. This is for test the scripts out before I go live on the main server. My problem is with the Object.sql when I import it it says there are 7900 odd items. I close my php and reopen and it still says the same, So i start the server and then when I get in the and recheck My php it says only 2800 odd items and all the Wood walls - Floors - Metal Floors are missing, As far as i can tell my looking on the map all Vehicles are there as are the Safes - Wood Crates - Lock boxes - Scaffold towers, It looks like its just the wall and floors missing, Now the thing is if I open up the Object.sql and then change The CharacterID (No) ie from say 345 to 0 and do this for all other instances of the CharacterID then the walls and floors spawn in.

How do I get it so it holds the CharacterID data and all items spawn in, Any help would be appreciated as i am total stumped

MegaZ
 
you need to import the charter DB as well, best bet is to backup the ENTIRE epoch db as a SQL dump and then create your new DB and import it

Is this private or hosted?
 
Hi FallingSheep. It is a private server I have just for testing out new scripts, I have done what you said and exported all as a dump but I get the same result. It shows in the new db after installing but then when I start the server it just loses all the walls, floors ect, Im using Pwnoz0r,s server and am try to get the db from a SS Server, Does both servers php myadmin need to be on the same version number? see below:
the one im trying to import
phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Host: 192.xx.xx.xxx
-- Generation Time: Jun 20, 2014 at 03:14 AM
-- Server version: 5.6.14
-- PHP Version: 5.4.27

Version on test server
-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 25, 2014 at 11:11 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.11

thanks for your time
 
it shouldnt matter the version as ther both 5.x.x and 4.x.x
you could try using SqlYog community edtion thats what i use, it fairly easy to use and setup
(if you have any issues let me know and i can help set it up and guide you on how to use it)

but it seems like your private DB is not saving the imports correclty.

SqlYog download link (use 11.51)
https://code.google.com/p/sqlyog/wiki/Downloads

other than that im not really sure why the imports dont save.
 
Thank sheep, I tried the progam you said and it still wont work. I think I might know why buy dont know how to get around it. The reason I think might be because I have deleted some players in Charactor ID DB. I have some older copies of the Charactor BD backed up that have the first 2000 odd entries which are mainly the ones i have deleted, and have been trying Un-Successfully to copy the entries from and old one and add it to the current one but it always fails when uploading with an error in the syntax:
This is what i get:

(1948, '2280900', 24, '2014-05-03 06:36:20', '2014-05-09 01:07:22', '[["ItemMap","Binocular","ItemMatchbox_DZE","ItemCrowbar","ItemKeyKit","ItemKnife","ItemToolbox","ItemKeyGreen257","ItemKeyYellow262","NVGoggles","ItemHatchet_DZE","ItemRadio","ItemWatch","ItemCompass","MakarovSD","BAF_LRR_scoped"],["ItemBloodbag","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","5Rnd_86x70_L115A1","FlareGreen_M203","ItemBandage","ItemBandage","ItemBandage","ItemBandage","8Rnd_9x18_MakarovSD","8Rnd_9x18_Makarov",["8Rnd_9x18_Makarov",4]]]', '["DZ_LargeGunBag_EP1",[["ItemKeyYellow262"],[1]],[["ItemPainkiller","PartWheel","ItemJerrycan","5Rnd_762x51_M24","HandGrenade_East","30Rnd_556x45_StanagSD","5x_22_LR_17_HMR","30Rnd_556x45_Stanag","10Rnd_762x54_SVD","30Rnd_545x39_AK","ItemSilverBar","30Rnd_9x19_UZI","5Rnd_86x70_L115A1"],[1,2,1,1,4,11,3,3,3,1,2,1,16]]]', '[110,[10939.9,6423.16,0.001]]', '[false,false,false,false,true,false,true,10[...]

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1948, '2280900', 24, '2014-05-03 06:36:20', '2014-05-09 01:07:22', '[["ItemMap",' at line 1
 
You must log in or register to reply here.
Back
Top