Hi, I agree with the post... I feel there should be an inbuilt backup routine.
(maybe built into something like MySQLFRONT or MyCC.) The shell script below, as far as I understand will not work with InnoDB only MyISAM tables. (please correct me if I am mistaken) It seems that MyCC is far far far behind "commercial" GUI's, but I feel that this is one part of the product that most people, even ISP's who use MySQL for free would pay for - i.e. a GREAT fully integrated MySQL GUI. Thanks Richard >> What we have done it right a small script: >> It logs on to the MySQL server. >> It then locks the databases and tables we have put in a config file. >> Simply copies the data files to a new directory. >> Unlocks the tables. >> Once this is done (copy if fast) you can tar or zip up the copied files. >> Simon >> -----Original Message----- >> From: Jonas Widarsson [mailto:[EMAIL PROTECTED]] >> Sent: 07 January 2003 15:07 >> To: [EMAIL PROTECTED] >> Subject: Backups mechanism >> 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 Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com ----------------------------------------------------------------------------- This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to Quantum Communications and is intended for the recipient(s) named above only. If received in error please notify the sender and destroy the original message and attachments. Emails may be monitored or recorded. It is the responsibility of the recipient to ensure that the e-mail and/or any attachment is virus free. The views expressed by the author may not reflect the views of Quantum Communications Limited. ----------------------------------------------------------------------------- --------------------------------------------------------------------- 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
