Probleme de migration de base mysql

[Albert]

Bonjour a tous,
Je viens de rentrer un nouveau client, et il me demande de lui injecte ca base de donnee qu il a exporte de chez son ancien hebergeur.

Par securite je veux injecter dans la nouvelle base mysql les tables une a une, en utilisant phpmyadmin:

Quand je lance la requette suivante:
CREATE TABLE `xxxx_attach_quota` (
  `user_id` mediumint( unsigned NOT NULL default '0',
  `group_id` mediumint( unsigned NOT NULL default '0',
  `quota_type` smallint(2) NOT NULL default '0',
  `quota_limit_id` mediumint( unsigned NOT NULL default '0',
  KEY `quota_type` (`quota_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `xxxx_attach_quota`
--

INSERT INTO `xxxx_attach_quota` VALUES (2, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (2, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (0, 5, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (0, 5, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (25, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (25, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (5, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (5, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (61, 0, 1, 2);
INSERT INTO `xxxx_attach_quota` VALUES (61, 0, 2, 2);
INSERT INTO `xxxx_attach_quota` VALUES (68, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (68, 0, 2, 3);

J ai ce message d erreur suivant:
MySQL a répondu:Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7

Quelqu un aurait il une idee?
Merci d avance.
Albert

[Toitoine]

Hello,

Essaye ça:
(2ème version)

Code: [Select]

CREATE TABLE `xxxx_attach_quota` (
  `user_id` mediumint(3) unsigned NOT NULL default '0',
  `group_id` mediumint(3) unsigned NOT NULL default '0',
  `quota_type` smallint(2) NOT NULL default '0',
  `quota_limit_id` mediumint(3) unsigned NOT NULL default '0',
  KEY `quota_type` (`quota_type`)
);

--
-- Contenu de la table `xxxx_attach_quota`
--

INSERT INTO `xxxx_attach_quota` VALUES (2, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (2, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (0, 5, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (0, 5, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (25, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (25, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (5, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (5, 0, 2, 3);
INSERT INTO `xxxx_attach_quota` VALUES (61, 0, 1, 2);
INSERT INTO `xxxx_attach_quota` VALUES (61, 0, 2, 2);
INSERT INTO `xxxx_attach_quota` VALUES (68, 0, 1, 3);
INSERT INTO `xxxx_attach_quota` VALUES (68, 0, 2, 3);


Il faut assigner une valeur au mediumint -> ici j'ai mis (3)
et tu peux enlever la ligne

Code: [Select]

ENGINE=MyISAM DEFAULT CHARSET=latin1;