Hi,
Hope I have faced this:
If we copy the files with 'cp' command, the permissions will not be
retained. You have to assign it on restoring. But in the mysqldump
utility, everything are retained as it is. Hope, mysqldump utility provides
more options related to db than that of 'cp' command.
Thanks
Visolve DB Team.
----- Original Message -----
From: "altendew" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, January 23, 2007 6:10 AM
Subject: Backup: Copy MYSQL Directory or use MysqlDump
I want to create a backup for my MySQL database every single night.
I am currently running on a linux box. I have a backup drive located as
/backup
Would it be more effecient to use mysqldump tool, or use the unix command
"dump or cp"
Andrew
--
View this message in context:
http://www.nabble.com/Backup%3A-Copy-MYSQL-Directory-or-use-MysqlDump-tf3061490.html#a8513292
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
