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" <[email protected]>
To: <[email protected]>
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
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
