SQL for beginners! How do you backup and restore a db?

eski2 · #1 01-04-2010, 05:13 PM

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.