Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
<cyt>
Peter> Well probably. But The problem is I can't backup database comfortable
Peter> way doing this (I can write a script of couse but there is one which
Peter> is doing almost the same thing and it's mysqldump)
Peter> so it looks like it wold be nice or for mysqldump to be able to
Peter> operate with load data infile format (you'll nead a number of files to
Peter> backup a database) or special format in which ou at first create
Peter> table without keys, then do all inserts into it and then do alter
Peter> table to add keys indeed.
Try:
mysqldump --tab=directory
This does basicly what you want.
After that, it's up to Heikki to fix Innobase to do delayed creation
of indexes.
Peter> At least it would be a standart way to quickly backup data and recover
Peter> it for all table handlers (backup probably does not work for all tablr
Peter> types yet)
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php