Re: Backup: Copy MYSQL Directory or use MysqlDump

2007-01-23 Thread altendew
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

Re: Backup: Copy MYSQL Directory or use MysqlDump

2007-01-23 Thread Daniel da Veiga
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

Re: Backup: Copy MYSQL Directory or use MysqlDump

2007-01-22 Thread Alex Arul
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

Re: Backup: Copy MYSQL Directory or use MysqlDump

2007-01-22 Thread ViSolve DB Team
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

Backup: Copy MYSQL Directory or use MysqlDump

2007-01-22 Thread altendew
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