Bug #859 Instruction on upgrading mysql to 4.1.0 alpha
Submitted: 16 Jul 2003 22:53 Modified: 27 Aug 2003 7:30
Reporter: Wai Siow Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1.0 alpha OS:Microsoft Windows (Windows XP)
Assigned to: Mark Matthews CPU Architecture:Any
Triage: D4 (Minor)

[16 Jul 2003 22:53] Wai Siow
Description:
I have upgraded the mysql server to the newest alpha version by following the guide given in the zip file (I downloaded this file from UUNet FTP).  The only one problem I encountered with the instruction is with this:

* Execute the 'mysql_fix_privilege_tables.sql' script in the 'scripts
  directory:
  
  	c:\mysql\bin\mysql < c:\mysql\scripts\mysql_fix_privilege_tables.sql

The server didn't allow me to do so due to an error:

ERROR 1046 at line 1: No Database Selected

Just think it might be good to let you guys know and can fix the instruction. Note that I was able to run the server just fine without having this successfully completed, so I wonder if this step is necessary.

How to repeat:
simply follow the guide and upgrade it to 4.1.0 alpha.

Suggested fix:
I think it's just a very small fix, I am just not too good with SQL and plus I think it's necessary to notify you guys.
[16 Jul 2003 23:46] Paul Dubois
Looks like the command in the README should be amended
to name the database:

c:\mysql\bin\mysql mysql < c:\mysql\scripts\mysql_fix_privilege_tables.sql
[17 Jul 2003 2:27] Sergei Golubchik
Better to add USE mysql; to the sql script
[17 Jul 2003 13:17] Wai Siow
When appened with the table name, a different error occurred

ERROR 1060 at line 9: Duplicate column name 'File_priv'

Now that looks like something more serious.
[24 Jul 2003 7:52] Alexander Keremidarski
No this warning is rather normal.

mysql_privilege_tables which is unix shell script displays message in the begining: 

"If your tables are already up to date or partially up to date you will"
"get some warnings about 'Duplicated column name'. You can safely ignore these!"
[24 Jul 2003 8:57] Paul Dubois
Two points:
1) He's using Windows, not Unix.
2) The "duplicate column" problem *is* a problem because the
instructions file doesn't indicate that mysql should be
invoked with the --force option. That means the
mysql_fix_privileges_table.sql script will terminate
when the first duplicate column error occurs.

Until the instructions are fixed, this problem will
still occur.
[27 Aug 2003 7:30] Mark Matthews
The '-f' flag has been added in the documentation. These instructions also become non-relevent when the new installer is ready (it applies the grant table changes automatically).