[Opensim-users] Database backups, recommended methods

[Gary Beck]

For backups I use the Data Export & Restore feature of MySQL Workbench. 
MySQL Workbench uses scripts to invoke mysqldump for you through a GUI 
dialog.

My process is: Shutdown Opensim and then use MySQL Workbench to export to a 
self-contained file.  That exports all the tables to a single file.  To 
restore I point to that file for import and it reloads it all.

I run Opensim at two different locations.  I take a copy of the exported 
dump file with me on a USB drive to restore the database when I change 
locations.  That seems to work well.  I have noticed some script state 
issues where I needed to reset a script or touch-start something after a 
restore.

----- Original Message ----- 
From: "missyfitz" <7minarets at gmail.com>
To: <opensim-users at lists.berlios.de>
Sent: Tuesday, June 07, 2011 18:12
Subject: [Opensim-users] Database backups, recommended methods


> What is the recommended method(s) for doing a database backup? Is it 
> simply a
> matter of backing up the mySQL database file to external storage or dvd, 
> or
> is there some method for exporting all the tables to a text file? I've 
> seen
> reference to the latter someplace, but don't have it bookmarked and am not
> sure if that's the better way to go, or possibly the only way to go...
>
> Am I safe simply archiving the mySQL database file itself, or should I be
> using some method to export all the tables / data to a separate file and
> then archiving that file? If so, can you describe briefly how to do the
> export to grab all the database data, or point me in the right direction?
> Also, is there an automated way (WinXP) to do this, say, every 6 hours, or
> is it best done manually?
>
> (I'm a mySQL novice, as I'm sure many people here are, so I think this 
> info
> clearly outlined would be beneficial to a lot of us)
>
> --
> View this message in context: 
> http://opensim-users.2152040.n2.nabble.com/Database-backups-recommended-methods-tp6451598p6451598.html
> Sent from the opensim-users mailing list archive at Nabble.com.
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users