ArcEmu: Update Database - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Update Database How do you update a database without wiping the world?

#1 User is offline   Imacellist2 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 25-June 10
  • Gender:Male

Posted 19 July 2010 - 12:21 AM

Firstly I understand how to implement a new database, that is easy. What I am trying to figure out how to do is only update the changed info and not wipe the world and install the new one with the new database. I know that anyone reading this is gonna wanna know why I would want to do this. Well the reason is that my friend and I have spent quite a bit of time making buildings out of benches and the last time we changed databases they were gone, since we rewrote over the entire world, that makes sense. So I want a way to just add/subtract whatever information is changed and added when I do a svn update. Any help would be appreciated.

Core version 3.3.5a
Database whydb
0

#2 User is offline   iEzri 

  • < Ace of spades >
  • Group: Contributor
  • Posts: 1,692
  • Joined: 22-December 08
  • Gender:Female
  • Interests:I'm likely to cause mischief
  • Server OS:Linux

Posted 19 July 2010 - 04:37 AM

View PostImacellist2, on 19 July 2010 - 12:21 AM, said:

Firstly I understand how to implement a new database, that is easy. What I am trying to figure out how to do is only update the changed info and not wipe the world and install the new one with the new database. I know that anyone reading this is gonna wanna know why I would want to do this. Well the reason is that my friend and I have spent quite a bit of time making buildings out of benches and the last time we changed databases they were gone, since we rewrote over the entire world, that makes sense. So I want a way to just add/subtract whatever information is changed and added when I do a svn update. Any help would be appreciated.

Core version 3.3.5a
Database whydb


hi there,

first of all you should backup your stuff before trying something strange. Then i would say you should export all your custom stuff and check if it is the same structure of our recent rev. of the db. Then interchanging this should not be that hard.
Posted Image I do not join. I lead.
0

#3 User is offline   cybersquare420 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 161
  • Joined: 01-April 10
  • Gender:Male
  • Location:Northern MI, USA

Posted 19 July 2010 - 07:41 AM

View PostiEzri, on 19 July 2010 - 04:37 AM, said:

hi there,

first of all you should backup your stuff before trying something strange. Then i would say you should export all your custom stuff and check if it is the same structure of our recent rev. of the db. Then interchanging this should not be that hard.

make the newdatabas seperate from the old one and use a database tool (i like toad) to do a data comparison... this will enable you to pull all the extra spawns and whatever from the old one and add it to the new one... (also a good way to merge two databases into one if you ever want to)
gl
0

#4 User is offline   Imacellist2 

  • Member
  • Pip
  • Group: Members
  • Posts: 27
  • Joined: 25-June 10
  • Gender:Male

Posted 19 July 2010 - 11:06 AM

Ok thanks guys. I will try that out and post here how it goes.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users