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
