View Single Post
  #1  
Old 01-04-2010, 05:13 PM
eski2
Hill Giant
 
Join Date: May 2008
Location: sydney
Posts: 177
Default SQL for beginners! How do you backup and restore a db?

I haven't seen any decent sites on it yet and I can't find anyone locally who uses it still (everyone says "I used to know how to do that...")

Looking at what ChaosSlayerZ did below I can see how to multiply something by a value, but I'm not sure how to set something to a constant.

"update loottable_entries set multiplier=multiplier*2;"

I suspect it's something like
Code:
UPDATE `PEQ`.`items` SET `loregroup`='0';
if i wanted to remove the lore tag from everything but i don't know how to backup and restore my version of the peq db if i am stuffing up, and the intro web sites never seem to think a student would need to.

Can anyone tell me how to backup/restore, and if they think my code makes sense? Or at least of a decent training website that covers that sort of thing? I guess backup/restore is the main thing.
Reply With Quote