>>>>> "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'
>> '
Hi!
Just use the --opt or --all options.
Without options, mysqldump tries to be as ANSI SQL clean as possible.
Regards,
Monty
