MySQL Passwords
How to Use PHP with HTML5 Programming
How to Develop an Object-Oriented Script

Periodic Upgrades of MySQL

New versions of MySQL are released periodically, and you can upgrade from one version of MySQL to a newer version. You can find upgrading information in the MySQL manual online.

However, there are special considerations when you upgrade. As a precaution, back up your current databases, including the GRANT tables in the mysql database, before upgrading.

MySQL recommends that you don’t skip versions. If you want to upgrade from one version to a version more than one version newer, such as from MySQL 4.0 to MySQL 5.0, you should upgrade to the next version first. After that version is working correctly, you can upgrade to the next version, and so on. In other words, upgrade from 4.0 to 4.1, then from 4.1 to 5.0.

Occasionally, incompatible changes are introduced in new versions of MySQL. Some releases introduce changes to the structure of the GRANT tables. For instance, MySQL 4.1 changed the method of encrypting passwords, requiring a longer password field in the GRANT tables.

After upgrading to the newer version, you should run the mysql_upgrade script. It repairs your files and upgrades the system tables, if needed. In versions prior to MySQL version 5.0.19, the mysql_upgrade script doesn’t run on Windows; it runs only on Unix.

On Windows, you can run a script called mysql_fix_privileges_tables with MySQL versions prior to 5.0.19. The script upgrades the system tables but doesn’t perform the complete table check and repair that mysql_upgrade performs.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Choose the Data for Your MySQL Database
How to Use PHP to Build an HTML5 Form with Complex Elements
How to Remove MySQL Accounts
How to Write Text to Files in PHP for HTML5 and CSS3 Programming
How to Read CSV Data in PHP for HTML5 and CSS3 Programming
Advertisement

Inside Dummies.com