DB mysql aus Versehen gelöscht

[Felix Strauß <FelixStrauss_(at)_gmx.de>]

Hallo,

ich habe die DB mysql auf meinem dedizierten Server aus Versehen
gelöscht. Ich habe nun auf meinem lokalen Rechner die DB mysql von
einer neuinstallierten Version exportiert und auf dem Server
importieren wollen. Dabei kommt aber eine Fehlermeldung, obwohl
ich den Dump nicht verändert habe. Hier meine Eingaben:
server53:/www/www1 # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12582 to server version: 3.22.32

Type 'help' for help.

mysql> create database mysql;
Query OK, 1 row affected (0.00 sec)

mysql> quit
Bye
server53:/www/www1 # mysql mysql < mysql.sql -u root -p
Enter password:
ERROR 1071 at line 11: Specified key was too long. Max key length is 256
server53:/www/www1 #


Der Dump:
# MySQL dump 8.8
#
# Host: localhost    Database: mysql
#--------------------------------------------------------
# Server version        3.23.22-beta-debug

#
# Table structure for table 'columns_priv'
#

CREATE TABLE columns_priv (
  Host char(60) DEFAULT '' NOT NULL,
  Db char(64) DEFAULT '' NOT NULL,
  User char(16) DEFAULT '' NOT NULL,
  Table_name char(64) DEFAULT '' NOT NULL,
  Column_name char(64) DEFAULT '' NOT NULL,
  Timestamp timestamp(14),
  Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,
  PRIMARY KEY (Host,Db,User,Table_name,Column_name)
);

#
# Dumping data for table 'columns_priv'
#


#
# Table structure for table 'db'
#

CREATE TABLE db (
  Host char(60) DEFAULT '' NOT NULL,
  Db char(64) DEFAULT '' NOT NULL,
  User char(16) DEFAULT '' NOT NULL,
  Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  UNIQUE Primary (Host,Db,User),
  KEY User (User)
);

#
# Dumping data for table 'db'
#

INSERT INTO db VALUES ('%','test%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');

#
# Table structure for table 'host'
#

CREATE TABLE host (
  Host char(60) DEFAULT '' NOT NULL,
  Db char(64) DEFAULT '' NOT NULL,
  Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  UNIQUE Primary (Host,Db)
);

#
# Dumping data for table 'host'
#


#
# Table structure for table 'tables_priv'
#

CREATE TABLE tables_priv (
  Host char(60) DEFAULT '' NOT NULL,
  Db char(64) DEFAULT '' NOT NULL,
  User char(16) DEFAULT '' NOT NULL,
  Table_name char(64) DEFAULT '' NOT NULL,
  Grantor char(77) DEFAULT '' NOT NULL,
  Timestamp timestamp(14),
  Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,
  Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,
  PRIMARY KEY (Host,Db,User,Table_name)
);

#
# Dumping data for table 'tables_priv'
#


#
# Table structure for table 'user'
#

CREATE TABLE user (
  Host char(60) DEFAULT '' NOT NULL,
  User char(16) DEFAULT '' NOT NULL,
  Password char(16) DEFAULT '' NOT NULL,
  Select_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Update_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Create_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Process_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  File_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  References_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Index_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL,
  UNIQUE Primary (Host,User)
);

#
# Dumping data for table 'user'
#

INSERT INTO user VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('%','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO user VALUES ('localhost','','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES ('%','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');  

MfG
Felix Strauß


---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql