��4.0.26��5.0.24a��

$mysqldump -d --no-data db_name > db_name.schema

$mysqldump -t db_name > db_name.insert

��

$mysql -u xxx db_name��< db_name.schema��

$mysql -u xxx db_name��< db_name.insert��

��

ERROR 1062(23000) at line 367��Duplicate entry '��'��fro key 1

��mysqldump��

��

mysql��ignore��-i��

��mysqlimport��

��

mysqlimport��Error:Table��'db_name.db_name' doesn't��exist when using table��db_name

��

----- Original Message -----

From: Yoshio Kawano

Sent: Wednesday, September 20, 2006 6:28 PM

Subject: [mysql 13371] mysql��4.0.26��5.0.24a��

��
ykawa��OS=Linux��

mySQL��4.0.26��5.0.24a��UP��SQL��
��

-</var/localhost.localdomain.err��>-------------------------------
060920 17:39:08 mysqld started
060920 17:39:09 InnoDB: Started; log sequence number 8 534940131
060920 17:39:09 [Note] Recovering after a crash using mysql-bin
060920 17:39:09 [Note] Starting crash recovery...
060920 17:39:09 [Note] Crash recovery finished.
060920 17:39:09 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060920 17:39:09 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060920 17:39:09 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
060920 17:39:09 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
060920 17:39:09 mysqld ended
-------------------------------------------------------------

��
    http://grebowiec.net/2006/08/10/131/
    ��
    ��SQL��
    ��
-<��>------------------------------
mysqld_safe --skip-grant-tables --user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysqld restart
-------------------------------------------------------------