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: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 4.1.0 alpha | OS: | Windows (Windows XP) |
Assigned to: | Mark Matthews | CPU Architecture: | Any |
[16 Jul 2003 22:53]
Wai Siow
[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).