On 1/23/07, Alex Arul <[EMAIL PROTECTED]> 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/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
