I used mysqlhotcopy and all is fine.
Daniel da Veiga wrote:
>
> 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
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 mysqldu
ltendew" <[EMAIL PROTECTED]>
To:
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 loca
hat of 'cp' command.
Thanks
Visolve DB Team.
- Original Message -
From: "altendew" <[EMAIL PROTECTED]>
To:
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
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