FAQs and Support Center

Migrating a Maple T.A. Installation to a new server

How would a Server Administrator go about migrating a Maple T.A. installation to a new server?

Basically there are 3 different places where Maple T.A. information is stored:
  • In Tomcat's webapps folder (e.g. C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\mapleta )
  • In the Maple T.A. folder (e.g. C:\Program Files\Maple T.A.)
  • In the PostgreSQL database
When migrating to a new server you won't need to backup the information in Tomcat's webapps folder, because all of this will be created by the Maple T.A. installer. So to migrate an existing installation to a new server, you'll need to backup the second and third items above.

The information you need to back up for the Maple T.A. folder above are the \records and \html\tmp folders. This contains details about all the classes, question banks and web content. You simply need to make a copy of these folders (e.g. C:\Program Files\Maple T.A.\records and C:\Program Files\Maple T.A.\html\tmp ).

To back up the Postgres database:
  1. Open up pgAdmin III.
  2. In the Object Browser pane, expand the PostgreSQL Database Server node followed by the Databases node (you may need the PostgreSQL password).
  3. Right-click on the mapleta node and select Backup. Choose the default selections and choose a location and file name for the backup.

After Maple T.A. has been installed on the new server (and after any patches and hotfixes have been applied) you can:
  • Move the backed up \records and \html\tmp folders to the new installation.
  • Copy the backed up database to the new Postgres installation as follows:
    1. Open the pgAdmin III tool on the new server.
    2. In the Object Browser pane, expand the PostgreSQL Database Server node followed by the Databases node.
    3. Right-click on your mapleta database node and select Delete / Drop to delete the database.
    4. Right-click on the Databases node and select New Database. Enter the same Name and Owner as the database you just deleted. Set the Encoding to UTF-8.
    5. Right-click on the newly created mapleta database node in the pgAdmin tree view and select Restore.
    6. Browse to the backed up database and click OK.

Finally, you will have to check that the path names in the database to ensure they are correct. To edit the pathnames in your database:
  1. Open the pgAdmin III tool.
  2. Expand Databases > mapleta > Schemas > public > Tables.
  3. View the system_properties table.
  4. In the key field, find MaplePath. In the corresponding value field, make sure this points to the copy of Maple included with Maple T.A. (e.g. C:/Program Files/Maple T.A./bin.win/cmaple.exe ).
  5. In the key field, find gatewayHomePath. In the corresponding value field, make sure this corresponds to your Maple T.A. installation folder (e.g. C:/Program Files/Maple T.A. ).
  6. Save the changes and exit PGAdmin III.

Did you find this article helpful?

© Maplesoft, a division of Waterloo Maple Inc. 2017.   • Terms of Use | Privacy | Trademarks | Site Map