Upgrading to WordPress 2.9 with MySQL 4.0
To upgrade to WordPress 2.9, you must also upgrade your MySQL 4.0 database to a newer version.
This process may take a few hours due to the length of time databases take to backup, set up, and restore. Let's get started in your Hosting Control Panel.
1. Backup Your Current WordPress Database
Use your Hosting Control Panel to backup your MySQL 4.0 database into which WordPress is installed.
2. Create a New Database
Use your Hosting Control Panel to create a new MySQL database using MySQL 5.0 or higher.
3. Restore Your Backed-Up Database to Your New Database
Use your Hosting Control Panel to restore your database backup into the new MySQL 5.0 or greater database.
4. Update Your wp-config.php File
Use your Hosting Control Panel to find the host name for your MySQL database. You will need this information to modify your wp-config.php file.
Modify Your wp-config.php File
- Open your
wp-config.phpfile in a text editor, such as Notepad.
If there is no file called
wp-config-sample.phpand save it as
wp-config.php, locate the section that looks like this example:/** The name of the database for WordPress */
/** MySQL database username */
/** MySQL database password */
/** MySQL hostname */
wp-config.phpfile displays your old database name and location and password, rather than this default information.
- Replace the following information with the information used to create your database:
putyourdbnamehereis your MySQL database name.
usernamehereis your MySQL user name.
yourpasswordhereis your MySQL password.
localhostis your MySQL host name.
- Upload your modified
You can now access your wp-admin panel and upgrade to WordPress version 2.9.