Hello Michael,
Wednesday, March 14, 2001, 4:41:21 PM, you wrote:
Peter>> Well I tried to do so but still it takes an amount of time to add the
Peter>> indexes...
Peter>> I think the good Idea would be to add to mysqldump an option to create
Peter>> the table without index, then insert all data indeed and then add keys
Peter>> required. This would be a good point in --opt mode or in other option
Peter>> :)
MW> This already happens when using LOAD DATA INFILE and MyISAM tables,
MW> but the Innobase table handler can't yet do this.
Well probably. But The problem is I can't backup database comfortable
way doing this (I can write a script of couse but there is one which
is doing almost the same thing and it's mysqldump)
so it looks like it wold be nice or for mysqldump to be able to
operate with load data infile format (you'll nead a number of files to
backup a database) or special format in which ou at first create
table without keys, then do all inserts into it and then do alter
table to add keys indeed.
At least it would be a standart way to quickly backup data and recover
it for all table handlers (backup probably does not work for all tablr
types yet)
--
Best regards,
Peter mailto:pz@stripped
