Hello,
I'm trying to upgrade to version 4.1.0-alpha of MySQL from version 3.23.51
on a Windows 2000 platform.
I've downloaded the binary distribution of 4.1.0-alpha and followed the
install process(README.1st) for an upgrade install.
At the step :
* Execute the 'mysql_fix_privilege_tables.sql' script in the 'scripts
directory:
c:\mysql\bin\mysql < c:\mysql\scripts\mysql_fix_privilege_tables.sql
i got the error message : ERROR 1046 at line 1: No Database Selected.
Indeed, the script does not specify a particular database when attempting
to ALTER table user...
Then i tryed to run this script with a mysqlfront client(connected as root)
on the 'mysql' database and got the following error list :
1060 - Duplicate column name 'File_priv'
Query:
ALTER TABLE user add File_priv enum('N','Y') NOT NULL
=====
1060 - Duplicate column name 'Grant_priv'
Query:
ALTER TABLE user add Grant_priv enum('N','Y') NOT NULL,add References_priv
enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv
enum('N','Y') NOT NULL
=====
1060 - Duplicate column name 'Grant_priv'
Query:
ALTER TABLE host add Grant_priv enum('N','Y') NOT NULL,add References_priv
enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv
enum('N','Y') NOT NULL
=====
1060 - Duplicate column name 'Grant_priv'
Query:
ALTER TABLE db add Grant_priv enum('N','Y') NOT NULL,add References_priv
enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv
enum('N','Y') NOT NULL
=====
1060 - Duplicate column name 'ssl_type'
Query:
ALTER TABLE user
ADD ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL,
ADD ssl_cipher BLOB NOT NULL,
ADD x509_issuer BLOB NOT NULL,
ADD x509_subject BLOB NOT NULL
=====
1054 - Unknown column 'Type' in 'columns_priv'
Query:
ALTER TABLE columns_priv change Type Column_priv
set('Select','Insert','Update','References') DEFAULT '' NOT NULL
=====
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
'func ADD type enum ('function','aggregate') NOT NULL' at line 1
Query:
ALTER func ADD type enum ('function','aggregate') NOT NULL
=====
1060 - Duplicate column name 'Show_db_priv'
Query:
ALTER TABLE user
ADD Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER alter_priv,
ADD Super_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Show_db_priv,
ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Super_priv,
ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Create_tmp_table_priv,
ADD Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Lock_tables_priv,
ADD Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Execute_priv,
ADD Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER
Repl_slave_priv
=====
1060 - Duplicate column name 'max_questions'
Query:
ALTER TABLE user
ADD max_questions int(11) NOT NULL AFTER x509_subject,
ADD max_updates int(11) unsigned NOT NULL AFTER max_questions,
ADD max_connections int(11) unsigned NOT NULL AFTER max_updates
=====
1060 - Duplicate column name 'Create_tmp_table_priv'
Query:
ALTER TABLE db
ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,
ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL
=====
1060 - Duplicate column name 'Create_tmp_table_priv'
Query:
ALTER TABLE host
ADD Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,
ADD Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL
=====
The joined file mysql_structure.sql contains my 'mysql' database structure.
* Another thing i can report is that when i attempt to stop the server
executing the command :
c:\mysql\bin\mysqladmin -u root shutdown
i can see the memory freeding in the task manager, but the process
mysqld-opt.exe is still running... Is it normal ?
* One of the reasons i am interested in version 4.1.0 is that it manages
replication with user variables and temporary tables.
Do i have to upgrade my master server(version 3.23.51) too or is it
possible to get safe replication only by upgrading my slave(s) ?
If i don't need to upgrade the master, can i use my slave'databases
(except 'mysql') to recover data in case of disaster ?
Thank you for your help.
Olivier Doucet(See attached file: mysql_structure.sql)(See attached file:
README.1st)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
