List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:February 10 2000 11:29pm
Subject:Trouble with mysqldump
View as plain text  
>>>>> "Peter" == Peter Zaitsev <pz@stripped> writes:

Peter> There is a little problem with mysqldump.
Peter> Mysql 3.23* have special options for tables IE max_rows,delay_key_write or
Peter> pack_keys.
Peter> It seems like it's not saved by mysqldump

Peter> So just mysqldumping and then restoring database will recreate a little bit
Peter> different tables:

Peter> +----------+
Peter> | count(*) |
Peter> +----------+
Peter> |      385 |
Peter> +----------+
Peter> 1 row in set (0.03 sec)

mysql> alter table g00hits pack_keys=1;
Peter> Query OK, 385 rows affected (9.73 sec)
Peter> Records: 385  Duplicates: 0  Warnings: 0

mysql> quit
Peter> Bye
Peter> <(pz@spylog)~>$ mysqldump -d st11 g00hits'
>> '


Just use the --opt or --all options.

Without options, mysqldump tries to be as ANSI SQL clean as possible.

Trouble with mysqldumpPeter Zaitsev9 Feb
  • Trouble with mysqldumpMichael Widenius11 Feb