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
spippin@stripped
>>> "Kees Hoekzema" <kees@stripped> 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@stripped]
> Sent: Wednesday, October 30, 2002 5:39 PM
> To: mysql@stripped
> 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 <mysql-thread123554@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-kees=tweakers.net@stripped>
> 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 <mysql-thread123558@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-spippin=mtctrains.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
