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