On 1/23/07, Alex Arul <
alex.lurthu@...> wrote:
> Hi,
>
> MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
> tables and copying them or shutting down the server and taring the entire
> MySQL directory if you are using innodb. If you are using innodb tables only
> you can run mysqldump with --single-transaction option to take a consistent
> backup even when the server is running. Hence both has advantages and
> disadvantages. It will more of depend on your use case.
>
Alex is right. Depending on how you'll want to be able to restore, and
how big your database is you may use different methods for backup. I
usually use mysqldump along with bzip2 for maximum compression, but I
have used tar in the past. "cp -av" retains permissions, making it
easy for restore, but its not a good option, as you can't compress
data nor restore pieces of information in an easy way.
You'll have to test and choose from multiple options in this matter.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysqlTo unsubscribe:
http://lists.mysql.com/mysql?unsub=lists@...
