EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Seeking advice on character data backups (https://www.eqemulator.org/forums/showthread.php?t=18908)

devlor 06-28-2005 10:25 AM

Seeking advice on character data backups
 
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. :)


All times are GMT -4. The time now is 05:14 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.