View Single Post
  #9  
Old 02-12-2009, 01:23 AM
Andrew80k
Dragon
 
Join Date: Feb 2007
Posts: 659
Default

You've probably already backed up your database...I hope. The thing to do would be to restore your database. Then begin applying the changes that you see in the changelog but make sure you compare the changelog with the files in the utils/sql/svn directory so that you don't duplicate columns. You don't want to update something twice. I would go through the changelog, compare the changelog entry to the sql directory to see if there is a related change. Import that sql file or if there is no sql file, use the entry in the changelog. Sometimes if the change was pretty small it seems like an sql file didn't get created and just the entry in the changelog was made. Sometimes a reference in the changelog will point you to a sql file. Keep in mind there are a number of people making changes, and while I think they try to be consistent it doesn't always happen. Since you have a custom database it is going to be a little harder for you to get up to date and kind of painful. It will be well worth it. Any changes I make I keep in a custom.sql file that I can basically just import after I have made a database update. It's much easier that way. But that's harder to accomplish if you didn't do it from the start and don't remember all your customizations. Good luck. Let us know if we can help somehow.
Reply With Quote