Yes I've seen most of MySQL USERS use BACKUP tables instead of mysqldump ... I don't know if it's for the fact the is easieste to restore?
-----Original Message----- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:59 AM To: MySQL List Cc: ROGGER ALEXIS VASQUEZ MARTINEZ Subject: Re: NewBie Question; Backups? >----- Original Message ----- >From: "ROGGER ALEXIS VASQUEZ MARTINEZ" <[EMAIL PROTECTED]> > > How do I make a Backup of a MYSQL database ,,, At 9:42 AM -0600 11/29/01, Tyler Longren wrote: >mysqldump -uusername -ppassword -hhostname dbname > dbname.sql > >That will dump the database 'dbname' into the file 'dbname.sql' If using at least version 3.23.25, then you can also use a BACKUP TABLE statement. See Chapter.Section 7.13 BACKUP TABLE Syntax (is pp 244 on my copy) for more details. The question I asked before is which is better? BACKUP TABLE allows for an easier restore perhaps? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --------------------------------------------------------------------- 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
