Wordpress 3.2 and above requires you to have a MySQL 5 database. To update your database to MySQL 5, you will have to follow the following steps.
We would recommend backing up sites before making any changes. This can be done by clicking "Backups" and then "Add New Backup" in http://cp.blacknight.com
cp.blacknight.com:
If you have installed Wordpress through our Application Vault and you want to manually update, you will need to follow these steps:
If you have manually installed Wordpress through FTP, you will need to follow these steps:
If you are getting a message saying that Wordpress requires PHP 5.2.4, please visit: https://help.blacknight.com/entries/22937526-changing-php-version
- Firstly, you will have to export the old MySQL 4.0 database. To do this, click "Databases" in http://cp.blacknight.com and then clicking on the database name. Then click the URL beside "Browse database manager". This will open a new window. Click the database name and then "Export". At the bottom of the page, click the box beside "zipped" and then click "Go". Save the file to your Desktop.
- You will have to create a new install of Wordpress in the Application Vault. To do this, click "Application Vault" in http://cp.blacknight.com and then click "Blog Software" and then click "Wordpress". Click "Install" on the next page and click on the domain you would like to install Wordpress on. Click "Next". Insert "/new" in the "URL Path" field and fill out your login details as desired and click "Next" and then "Finish". This will install the latest version of WordPress and a MySQL 5.0 database.
- You will now have to update Wordpress. To do this, Login to the Admin area by clicking "Login" under "Entry Point". From there, you will see a yellow message "WordPress (VERSION_NUMBER) is available! Please update now". Click "Please update now" and on the next page click "Update Automatically". This will automatically update Wordpress to the latest version.
- You will then have to import the zipped MySQL 4.0 database to the new MySQL 5.0 database. Before you do this however you will need to remove the 'Create New Database' statement, this can be done by opening the .sql file in a text editor, search for the text “CREATE DATABASE”, and then delete this line containing the create database command (make sure to have made a copy of the orginal database before saving this however, just incase a mistake is made). Then Save the file.
Click "Databases" in http://cp.blacknight.com and you will see a new database. Click the new database name and click the URL beside "Browse database manager". This will open a new window. Click the database name and then "Import". Click "Browse" and find the zipped file on your Desktop and then click "Go". - You will now have to change the URL path of the two Wordpress installs. To do this, click "Application Vault" in http://cp.blacknight.com and then click "Blog Software" and then click "Wordpress". Click the domain with the old installation of Wordpress and then click "Change URL Path" and insert "/old" in the "URL Path" field and click "Submit". Now you will have to change the URL path of the new installation. To do this, click "Application Vault" in http://cp.blacknight.com and then click "Blog Software" and then click "Wordpress". Click the domain with the new installation of Wordpress and then click "Change URL Path" and replace "/new" in the "URL Path" field with "/" and click "Submit".
If you have manually installed Wordpress through FTP, you will need to follow these steps:
- Firstly, you will have to export the old MySQL 4.0 database. To do this, click "Databases" in http://cp.blacknight.com and then clicking on the database name. Then click the URL beside "Browse database manager". This will open a new window. Click the database name and then "Export". At the bottom of the page, click the box beside "zipped" and then click "Go". Save the file to your Desktop.
- You will then have to create a new MySQL 5.0 database. To do this, click "Databases" in http://cp.blacknight.com and then "Add New Database". Select "MySQL (MySQL5 Databases)" and click "Next". Fill out your login details as desired and click "Next" and then "Finish".
- You will then have to import the zipped MySQL 4.0 database to the new MySQL 5.0 database. Before you do this however you will need to remove the 'Create New Database' statement, this can be done by opening the .sql file in a text editor, search for the text “CREATE DATABASE”, and then delete this line containing the create database command (make sure to have made a copy of the orginal database before saving this however, just incase a mistake is made). Then Save the file.
Click "Databases" in http://cp.blacknight.com and you will see a new database. Click the new database name you created and click the URL beside "Browse database manager". This will open a new window. Click the database name and then "Import". Click "Browse" and find the zipped file on your Desktop and then click "Go". - You will now have to change the Config file in Wordpress to connect to the new database. You will have to login to your FTP client with your FTP details. You can find information on how to find your FTP details here:https://help.blacknight.com/entries/22936286-where-do-i-find-my-ftp-details. Navigate to "/yourblogdirectory/wp-config.php" in your FTP client and right click and the click "edit". You will have to replace the old database details with the new ones. You can find more information on this here: http://codex.wordpress.org/Editing_wp-config.php.
- You will now have to update Wordpress. To do this, Login to the Admin area by navigating to . From there, you will see a yellow message "WordPress (VERSION_NUMBER) is available! Please update now". Click "Please update now" and on the next page click "Update Automatically". This will automatically update Wordpress to the latest version.
If you are getting a message saying that Wordpress requires PHP 5.2.4, please visit: https://help.blacknight.com/entries/22937526-changing-php-version
DirectAdmin:
To update Wordpress to 3.2 and above, DirectAdmin users will have to move to our new system. More information can be obtained here: http://www.blacknight.com/client-migration.html.
Comments
0 comments
Article is closed for comments.