[gull] Migration des Utilisateur de Mysql 3.23 -> 4.1

[Anthony Assi]

Bonjour,

Je Migre une Base Mysql *3.23.52 a **4.1.12,
*J'ai noté une difference entre les tables USER de la base Mysql,



#
# Table structure for table `user` on Mysql *3.23.52*
#

CREATE TABLE `user` (
  `Host` char(60) binary NOT NULL default '',
  `User` char(16) binary NOT NULL default '',
  `Password` char(16) binary NOT NULL default '',
  `Select_priv` enum('N','Y') NOT NULL default 'N',
  `Insert_priv` enum('N','Y') NOT NULL default 'N',
  `Update_priv` enum('N','Y') NOT NULL default 'N',
  `Delete_priv` enum('N','Y') NOT NULL default 'N',
  `Create_priv` enum('N','Y') NOT NULL default 'N',
  `Drop_priv` enum('N','Y') NOT NULL default 'N',
  `Reload_priv` enum('N','Y') NOT NULL default 'N',
  `Shutdown_priv` enum('N','Y') NOT NULL default 'N',
  `Process_priv` enum('N','Y') NOT NULL default 'N',
  `File_priv` enum('N','Y') NOT NULL default 'N',
  `Grant_priv` enum('N','Y') NOT NULL default 'N',
  `References_priv` enum('N','Y') NOT NULL default 'N',
  `Index_priv` enum('N','Y') NOT NULL default 'N',
  `Alter_priv` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`Host`,`User`)
) TYPE=MyISAM COMMENT='Users and global privileges';




#
# Table structure for table `user` on Mysql *4.1.12*
#
CREATE TABLE `user` (

  `Host` varchar(60) collate utf8_bin NOT NULL default '',

  `User` varchar(16) collate utf8_bin NOT NULL default '',

  `Password` varchar(41) collate utf8_bin NOT NULL default '',

  `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',

  `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',

  `ssl_cipher` blob NOT NULL,

  `x509_issuer` blob NOT NULL,

  `x509_subject` blob NOT NULL,

  `max_questions` int(11) unsigned NOT NULL default '0',

  `max_updates` int(11) unsigned NOT NULL default '0',

  `max_connections` int(11) unsigned NOT NULL default '0',

  PRIMARY KEY  (`Host`,`User`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';



Comment est-ce que je pourrais proceder a la migration des Users ?