The info for mysqldump is at: http://www.mysql.com/doc/en/mysqldump.html
We have a databse of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would recommend, though, saving your larger tables to a separate file to make the import(if you ever need to do it) go faster. Scott Pippin [EMAIL PROTECTED] >>> "Kees Hoekzema" <[EMAIL PROTECTED]> 10/30/02 10:57AM >>> Hey, Use mysqldump. See the manual / cli help for how to do it :0 -kees > -----Original Message----- > From: Silmara [mailto:silmara.sami@;uol.com.br] > Sent: Wednesday, October 30, 2002 5:39 PM > To: [EMAIL PROTECTED] > Subject: Backup InnoDB > > > How can I do backup of only one DataBase? And How can I do recovery the > data? > > I'm working with MySQL ( InnoDB) and I have three DataBase in my > TableSpace. > But I would like doing backup of only one. > > regards, > > Sil > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
