« Return to Thread: Backup: Copy MYSQL Directory or use MysqlDump

Re: Backup: Copy MYSQL Directory or use MysqlDump

by ViSolve DB Team-2 :: Rate this Message:

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" <andrew@...>
To: <mysql@...>
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/mysql?unsub=mysqlsupport@...
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@...

« Return to Thread: Backup: Copy MYSQL Directory or use MysqlDump