Would anyone care to share any batch files / commands / scripts they may have on automating a database backup for characters? I'm specifically looking for pointers on backing up only those tables / values necessary for a seamless restoration of all data related to characters on the server.
Here's what I'm currently using (in a batch file), though I suspect it may be a bit overkill:
Code:
mysqldump --user=**** --password=**** eq account character_ character_backup eventlog faction_values guild_alliances guild_controllers guilds player_corpses player_corpses_backup variables inventory sharedbank petitions object_contents altadv_vars aa_timers timers logs hackers quest_globals name_filter > EQCharacterBackup.sql
While this seems to work, I'd really like to trim out any unnecessary "fluff" and perhaps get a heads-up from someone knowledgeable if I've omitted something important.
Thanks in advance to any who can shed some light on this for me.