Backing up and Restoring Printer Installer

This page will explain how to backup and restore Printer Installer. There are two parts of Printer Installer that need to be backed up.
  • Database
  • Web Site Files

Backing Up Printer Installer

Backing Up the Database

Use any MySQL database backup software to backup the MySQL database. Follow the below procedures to back up the Printer Installer database with the built in "mysqldump" command-line program:

IMPORTANT: Reference the C:\inetpub\wwwroot\config\settings.php file to see the values for the following items in the script example: DBName, DBUser, & DBPassword.

  1. From the server running MySQL, Click on Start and then type CMD.  A command prompt window will open.
  2. Change Directories to the C:\program files\mysql\MySQL Server 5.5\bin directory by typing cd "program files\mysql\MySQL Server 5.5\bin"
  3. Type mysqldump  ‐‐user=[DBUser] ‐‐password=[DBPassword] ‐‐single-transaction ‐‐add-drop-database ‐‐databases [DBName] > C:\backup.sql  * See note below Note: The values for DBName, DBUser, and DBPassword in the above script can be found in the C:\inetpub\wwwroot\config\settings.php file.
  4. Setup a scheduled task that runs as the system account to regularly export the database and then have your regular file backup (shadow copy or similar) copy the exported database file daily, keeping many previous copies of the database, so that you can have a good copy of the database to use for a database restore if needed.

Backing Up Web Site Files

Use any file backup software to back up the files contained in the Printer Installer Web site.  Follow these steps to manually create a backup copy of the Web site files.

  1. Open a windows explorer window by Clicking Start, type Run, and press Enter.
  2. Type Explorer and press Enter
  3. In the Explorer window  browse to the C:\inetpub\wwwroot folder and copy all folders and files it contains.  Paste them into a folder for backup.

Restoring Printer Installer

Restoring Web Site Files

Follow the below procedures to manually restore the Printer Installer Web site files.

  1. Copy all of the files and folders from the web site backup folder and paste them into the C:\inetpub\wwwroot folder, and overwrite any existing files.
  2. Right click the c:\Inetpub\wwwroot\cache folder and select "Properties", then click on the "Security" tab, click the "Edit..." button, click the "Add..." button, click the "Locations..." button, select the local computer object at the top and click "OK", enter IUSR and click "OK", check the Allow box for Modify and click "Apply", then click "OK", then click "OK".

Note:If you are restoring to a different server, check the C:\inetpub\wwwroot\config\settings.php file to make sure the MySQL database server has the correct IP address entry.

Restoring the Database

Use any MySQL database backup/restore software to backup/restore the MySQL database. Follow the below procedures to restore the Printer Installer database with the built in MySQL command-line program:

Follow the below procedures to restore the Printer Installer database:

Reference the C:\inetpub\wwwroot\config\settings.php file to see the values for the following items in the script example: DBName:, DBUser:, and DBPassword:

Restore the database by doing the following:

  1. From the server running MySQL, Click on Start and then type "CMD".  A command prompt window will open.
  2. Change directories to the C:\program files\mysql\MySQL Server 5.5\bin directory by typing cd "program files\mysql\MySQL Server 5.5\bin"
  3. Type mysql  ‐‐user=DBUser ‐‐password=DBPassword < C:backup.sql
  4. In a Web browser go to the Administrator login (http://WebServer/Admin), and login to verify the database has been restored.

Restoring Printer Installer to a different server

On the new server do the following:

  1. Create a C:\inetpub\wwwroot folder and copy and paste the Printer Installer web site files that have been backed up from the original server's C:\inetpub\wwwroot folder.
  2. Install Printer Installer on the new server. During the install, the MySQL server username, password and datatabase name will be read from the C:\inetpub\wwwroot\config\setting.php file and used for the new MySQL installation allowing the same setting.php file to be used on new server.
  3. Follow the Restoring Printer Installer section instructions above to restore Printer Installer web files and database content. Note: Because the Printer Installer setup program used in step 2 could contain newer web site files, you should copy the original server web site files into the c:\inetpub\wwwroot folder again as specified in the Restoring Printer Installer section above.