(mysql.info) downgrading-to-4-1

 
 2.11.1 Downgrading to 4.1
 -------------------------
 
 After downgrading from MySQL 5.0, you may see the following information
 in the `mysql.err' file:
 
      Incorrect information in file: './mysql/user.frm'
 
 In this case, you can do the following:
 
   1. Start MySQL 5.0.4 (or newer).
 
   2. Run `mysql_fix_privilege_tables', which will change the
      `mysql.user' table to a format that both MySQL 4.1 and 5.0 can use.
 
   3. Stop the MySQL server.
 
   4. Start MySQL 4.1.
 
 If the preceding procedure fails, you should be able to do the
 following instead:
 
   1. Start MySQL 5.0.4 (or newer).
 
   2. Run `mysqldump --opt --add-drop-table mysql > /tmp/mysql.dump'.
 
   3. Stop the MySQL server.
 
   4. Start MySQL 4.1 with the -skip-grant option.
 
   5. Run `mysql mysql < /tmp/mysql.dump'.
 
   6. Run `mysqladmin flush-privileges'.

Info Catalog

(mysql.info) downgrading

automatically generated byinfo2html