We use mysqlhotcopy as a command line script set to run daily as a cron job. Seems to work fine. You can add flags that allow you to maintain previous copies of the db in case you need to go back a version or two. It took about 10 minutes to set up. We then run TSM backups to storage of the script output.
mysqlhotcopy db_name [/path/to/new_directory]
You can find out more in the manual at:
http://www.mysql.com/doc/en/mysqlhotcopy.html
and here's a general intro:
http://www.mysql.com/doc/en/Backup.html
Sorry, there is some reading involved :-)
Jon Bertsch
At 04:07 PM 1/7/2003 +0100, you 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?
---------------------------------------------------------------------
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
--------------------------------------------------------------------- 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
