Web Wiz
  Knowledgebase Knowledgebase      Customer Login Customer Login


Web Wiz Forums mySQL Upgrade


The following step by step guide describes how to upgrade the mySQL version of Web Wiz Forums.
  1. IMPORTANT; Backup your existing mySQL Server database. You may need to check with your web host as to what backup tools they give you. If you are using your own server make an SQL Dump using the tools from www.mysql.com.
     
  2. Use a zip utility program to extract the files to your hard drive keeping the original file structure intact.
    Extract files using a zip extraction tool
  3. Using an FTP Program remove from your web space all the old files and images for the existing forum you want to upgrade, just keeping the uploads folder that contains content that your members have uploaded.

  4. Upload using your FTP Program the forum directory containing all the files and images onto your web space making sure that the files stay in their original directories.
    Upload the files using FTP
  5. The forums database folder located at forum/database needs to have read, write, and modify permissions set on it, so that the installation wizard can write the database settings to the configuration files in this folder. Check with your web host that you have these permissions set, or if running the server yourself have a look at Setting Read, Write, and Modify Permissions.

  6. Type into your web browsers address bar the domain name and folder that you have uploaded the forum to. The Web Wiz Forums installation/upgrade wizard will start automatically in your browser.
    Navigate to the location where you have uploaded Web Wiz Forums
  7. Select the type of upgrade that you require then click Next.
    Select Installation Type
  8. Select the database type that you are using, MySQL 4.1 or above, then click Next.
    Select the type of Database
  9. On the Database Connection Page, enter your information as follows;

    • Server - This will be the name or location of the mySQL instance (URI, IP address, or localhost)
    • Database Name - This is the name of the actual database
    • Database Username - This will be the name of the user account you use to login into the mySQL database
    • Database Password - This will be the password that you use with the mySQL Username above

    Once you have filled in the fields, click Test Database Connection.
    Database Connection Details
  10. The Test Database Connection window will open, click Close Window
  11. Test Database Connection
  12. If the connection was not successful go back to stage 9 and complete the connection details again. If the database connection was successful click Next.

  13. The upgrade will now begin. This may take sometime to complete. Once it has completed you should see a message like the one below, click the Forum Homepage link to view your forum.
    Web Wiz Forums Datbase Upgrade Complete
  14. Your forum logins will remain the same including for any admin accounts.
     
  15. If you find that you are getting errors and pages not displaying please see Troubleshooting and Common Errors.
     



Become a Fan on Facebook Follow us on Twitter Find us on Google+ Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 5977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, United Kingdom.

Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.


Copyright ©2001-2016 Web Wiz Ltd. All rights reserved.