adding spawns

[mudman]

this is something I have been dying to do on my server, it seems


with FQAdmin I go to the spawns tab and add reccord , click on map to add in the loc i want add the spawn data and then commit changes?

I am very worried about FQAdmin currupting my database? Is this the best way? I would like to add a bunch of spawn events on my server. should I use FQAdmin to do this?

Sorry new to complex database management programs such as these. Though I have worked with databases as a user quite a bit.

Ty )

M.

[wurmslayer2k]

Theres no " best way ". FQAdmin is a good tool, yes, but its all an opinion. If your worried about it ruining your DB, then just make a backup of it and replace it if it does get corrupt.

[mudman]

Hi

Thanks, so FQAdmin is about the best way to do it sounds. Do you have any tips? Also this is a dumb question but is there a specific directory that should be backed up in mySQL? I dont want people to lose thier characters if I have a problem.

Nice website btw.

M.

[emun00b]

Backup all of the SQL files in your 'c:\mysql\bin' folder and you'll be fine. That's overkill but will ensure no data is lost.

[Shawn319]

the .sql files in the mysql/bin folder hold no data. thay are only the origional sql file you copied tere to begin with. the only way to back your DB up is to "dump" the database into a file.

open a commandline and run mysqldump.exe eq > dumpedfile.sql

or something like that hehe. run mysqldump.exe for CL argument help if that doesnt work.

[emun00b]

Ahh... /em looks at his name. Decides not to change it!

[wurmslayer2k]

Thank you for the comment on my website, mudman.:p . Read Shawn's post, that is the easiest way I think. I just copy the sql file from the c:/mysql/bin directory and paste it in a different place. If I accidently corrupt it, I simply go to ( in the mysqlwinadmin thing ) Databases>right click on the eq database>click "drop database". Then re-create the database "eq" and get the sql file from where you pasted it. Copy and paste it back into the mysql/bin directory, run mysql.exe, use eq > source db.sql. And there you have it =)

**EDIT**

Lol, like I said, there's no "Best Way", it is a very, very handy tool in my opinion and it is a heavily easy way to manage your database.

[mudman]

Yea, I quess there is no substitute for expermentation )-, I decided just to back up everying on a removeable hard drive and just swap till I know what I am doing. Seems easy enough to make backups though from what you said. I am realy looking forward to populating zones with imaginative spawns. )

M.

[wurmslayer2k]

Yeah, that makes the emu all but more fun :p:p:p:p:p