List:General Discussion« Previous MessageNext Message »
From:Scott Pippin Date:October 30 2002 5:58pm
Subject:RE: Backup InnoDB
View as plain text  
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


Thread
Backup InnoDBSilmara30 Oct
  • RE: Backup InnoDBKees Hoekzema30 Oct
RE: Backup InnoDBScott Pippin30 Oct