Character and Item Backup Newbie Questions
Hey guys. I have some probably really annoying newbie questions about backing up characters and items from the database. I've run into some problems with my server, got confused with updating and converting to a localhost and just decided to start again from scratch. I searched and searched on google and forums, and I'd find *what* to backup, but not necessarily *where* to find this data. I use HeidiSQL to read .sql files.
Ok, so what file exactly am I opening up to backup database stuff? Am I looking in EQ/SQL folder? I opened up drop_system.sql in that folder and found all my items I created under "Table: items" and I also found "account," "character_," "character_backup," "inventory," and "shared bank." It seems it doesn't matter which .sql file you open, it all gives you the same info?
So would I just choose the tables I need to back up and right click > "Export Database as SQL"? And if I only wanted to backup all the items I added (in case any default items got updated or something), how would I go about doing that? Export grid rows? Would I then just source the exported SQL/grid rows when I finish setting up my server?
Again, I'm sorry for the newbie questions guys, I really did search, and maybe I searched poorly, but I couldn't find any help that assumes you're a *complete* MySQL idiot. Also, sorry for the long post, I wanted to be somewhat thorough. Thanks for any reply!
|
Threaded Mode
