On Tue, 7 Jan 2003, Jonas Widarsson wrote: > Hello world! > Every attempt I have made to find a decent way of backing up a database > ends up with tons of reading to show hundreds of ways to do database > backups. > > I want to know which way to do complete backups is most commonly used by > professional users. (Windows and Linux) > > I have pleasant experience from Microsoft SQL Server 2000 where backung > up is very confident, easy to understand and just a matter of a mouse click. > > Is there any similarily convenient way to do this with mysql, for example: > * a shell script (windows / Linux) that works as expected without days > of configuration? > * scheduled backups, complete or differential? > * GUI-solution ??? (mysql control center does not even mention the word > backup) > > Backup is such an important issue. Why does it seem like it is something > that the developers don't care about?
I use mysqldump to do a total backup of my database. This is done once a day just after midnight. The file is then taken up by our tape backup software. I do hourly backups of our more important databases, also using mysqlbackup. Works fine and I have used it for restorals on a number of occasions. Even better, mysqlbackup generates SQL files, which, with a little manipulation, can be imported into other database systems. -- Aaron Clausen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
