[Opensim-users] Database backups, recommended methods

[missyfitz]

So is it safe to just backup the database file itself? If I needed to restore
a database or, for example if I reinstall Windows and mySQL, can I take an
actual database file and just load it up in a fresh copy of mySQL?

Or does a database have to be exported to a text file in order to then be
imported / usable in a new copy of mySQL? 

Because if I can just use an actual copy of a database as a backup then all
I really need to do is include it in my normal system-wide backup scheme,
which basically just creates a mirrored dataset in a different location... 

Every site I read regarding backing up databases always talks about the
'mysqldump' procedure, but never about essentially taking the database file
itself and just burning it onto a dvd or whatever.

Are there any password issues with moving a database to a new mySQL
installation or to a new computer entirely, if I were to just burn the
database itself onto a dvd or add it into my existing backup scheme?


--
View this message in context: http://opensim-users.2152040.n2.nabble.com/Database-backups-recommended-methods-tp6451598p6456477.html
Sent from the opensim-users mailing list archive at Nabble.com.