On premise schools
      Back to home
      1. Help Articles
      2. Technicians
      3. On premise schools

      How to back up XUNO for on premise schools

      Note: Your XUNO database is hosted on a MySQL database platform and requires the free MySQL Workbench Utility to perform the backup. Please have your technician follow these steps to backup your XUNO database.

      In this article

      Install and configure the MySQL Workbench Utility

      You only need to perform this step once and then periodically install the latest MySQL Workbench Utility update.

      1. On your XUNO server, open your browser and navigate to http://dev.mysql.com/downloads/
      2. Scroll down the page until you find the MySQL Workbench option and then click on the corresponding DOWNLOAD link.
      3. Installing MySQL Workbench on a Windows computer requires your computer to have the Microsoft .NET Framework 4 Client Profile and Microsoft Visual C++ 2010 Redistributable Package (x86) installed. Please download and install these if you do not have them installed.
      4. Make sure that the MySQL website has selected the correct version from your operating system. You can change your download version using the drop-down list. If possible, we recommend that you download the 64-bit version of MySQL Workbench.
      5. When you are ready click on the Download link.
      6. After your download has completed, double-click on the downloaded file to begin the installation. Follow the installation steps to complete the installation.
      7. Open your MySQL Workbench Utility.
      8. Click on the + button located next to the “MySQL Connections” heading on the dashboard.
      9. Enter “localhost” as the Connection Name, then click OK to save the changes.

      Important Tip
      You should always back up your XUNO database and XUNO files to a different location and NOT onto the same server.

        

      Backing up your XUNO database and files

      1. Open your MySQL Workbench Utility.
      2. On your dashboard under MySQL Connections, double-click on the localhost item.
      3. Enter your MySQL password and click OK.
      4. Click on the Data Export option in the left menu (under the Management section), and re-enter your MySQL password.
      5. Select your XUNO database (schema) from the Data Export pane. Your XUNO database will either be called “studentmanagement” or “xunodb”.
      6. Click the Export to Self Contained File option, and click on the … browse button to choose where to save your export. Name the export file: xunobackup_Y-M-D.sql (where Y is your current year, M is your current month, and d is your current day). For example: xunobackup_2014-09-01.sql. Do NOT save your backup onto your XUNO server – please choose a different location.
      7. Ensure that the Dump stored Procedures and Functions and Create Dump in a Single Transaction (self-contained file only) are both selected.
      8. Click on the Start Export button to begin and re-enter your MySQL password.
      9. Your database will back up to your specified location. It can take up to 20+ minutes to back up your entire database during which time the log will not show any progress. Please wait until the log has confirmed that your database has successfully backed up.
      10. Check the file size of your backup file in your backup location. The file size must be larger than zero kilobytes, and should generally be larger than 10MB. If you are unsure, please contact our support team to confirm that your backup occurred successfully.
      11. You can also do the following as a second backup of your files:
        1. Login to the XUNO server as an administration.
        2. Open your file explorer to the location where you installed XUNO (usually C:\Inetpub\).
        3. Right-click on the XUNO folder and select Copy.
        4. Navigate to a folder that is in your backup location. Do NOT save your backup onto your XUNO server - please choose a different location.
        5. Right-click in the backup location and choose Paste to backup your entire XUNO working files.