[Opensim-users] Database backups, recommended methods

[Mimetic Core]

HI Missyfitz,

Many people will have their own recommendations for backing up 
databases, all relative to their own experience levels.  As far as I'm 
concerned (even as a seasoned tech) tasks like database management 
should be easy and require as little of our precious time as possible.  
There's a great web-based tool for backing up databases that I use and 
highly recommend to anyone of any experience level called MySQLDumper.  
It's open source and can be found here:

http://www.mysqldumper.net

I won't go into too many details as you can read about them for 
yourself, but I will say that it can back up single/multiple databases 
and compress them which makes archiving them very easy.  It takes about 
1 minute to install and has a fairly straightforward interface.  It does 
require a functional web server, preferably on the same machine as your 
SQL database(s) which is usually the case.

Check it out.  If you don't get all the info you need from the site, 
I'll be happy to help you in any way I can as I've been using 
MySQLDumper for some time now.  Cheers.

core

On 6/7/2011 5:12 PM, missyfitz wrote:
> 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