[HELP] Backing up / saving all characters-PlayerGUID?

[noodleman1]

Hello there,
I want to make a back-up of my characters, but I can´t seem to find out how to do this without MySQL management tools... I use mangos and their console ( mangosd.exe ) tells about a command called ''writepdump'' which saves characters, but this requires $filename and $playerGUID. I hav esome quetsions concerning these requirements:

-Should I include the path with the filename? ( C:\blabla\CharacterBackup ) ?
-How do I find out the character GUID?

Thanks!

[TheSpidey]

If you want to save all characters, just backup your logon database. Why don't you get Navicat / SQLYog?

[noodleman1]

As mentioned in my first post: without mysql management tools...

[waymirec]

just use the mysqldump command from the console.


mysqldump -p <database> <table> > backup.sql

[troy23]

just use the mysqldump command from the console.


mysqldump -p <database> <table> > backup.sql

So can u dump multiple tables at once into the same .SQL file with this command??
If so how can i do it?

[waymirec]

you could either dump the entire database

mysqldump -p <database> < database.sql

or you could dump the individual tables you want and just append them into a single file

mysqldump -p <database> <table1> >> databse.sql
mysqldump -p <database> <table2> >> databse.sql
mysqldump -p <database> <table3> >> database.sql
etc...