BACKUP/RESTORE speed and delayed index creation.

2001-06-01 Thread Peter Zaitsev
Hello mysql, Today I played a little bit with two different ways of backup - first one is to use BACKUP TABLE (which works for myisam only) and the second one is SAVE DATA/LOAD DATA. In both cases if I'm not mistaken the file is wrote by mysqld server so there is no communication

Re: BACKUP/RESTORE speed and delayed index creation.

2001-06-01 Thread Heikki Tuuri
Hi! At 05:44 PM 6/1/01 +0400, you wrote: Hello mysql, Today I played a little bit with two different ways of backup - first one is to use BACKUP TABLE (which works for myisam only) and the second one is SAVE DATA/LOAD DATA. In both cases if I'm not mistaken the file is wrote by mysqld