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.
Backing up and Restoring MySQL or MSSQL Databases
2. Create a New Database
Use your Hosting Control Panel to create a new MySQL database using MySQL 5.0 or higher.
Creating MySQL or SQL Server Databases for Your Hosting Account
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.
Backing up and Restoring MySQL or MSSQL Databases
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.
Why is WordPress unable to connect to my database during install?
Modify Your wp-config.php File
- Open your
wp-config.phpfile in a text editor, such as Notepad.
If there is no file calledwp-config.php, openwp-config-sample.phpand save it aswp-config.php. - In
wp-config.php, locate the section that looks like this example:/** The name of the database for WordPress */
define('DB_NAME', 'putyourdbnamehere');
/** MySQL database username */
define('DB_USER', 'usernamehere');
/** MySQL database password */
define('DB_PASSWORD', 'yourpasswordhere');
/** MySQL hostname */
define('DB_HOST', 'localhost');NOTE: The
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
wp-config.phpfile.
You can now access your wp-admin panel and upgrade to WordPress version 2.9.
