TSF – Giải pháp IT toàn diện cho doanh nghiệp SMB | HCM

P10 - Backup Restore SnipeIT on Windows XAMPP

SnipeIT – P10 Backup Restore SnipeIT on Windows XAMPP | Manual + Scheduled Tasks

Running Snipe-IT on Windows with XAMPP is common in lab environments, internal IT asset tracking systems, and even small production setups.

However, one critical question remains:

👉 What happens if your system crashes?
👉 What if MySQL becomes corrupted?
👉 What if you accidentally delete important asset data?

Without a proper Backup Restore SnipeIT strategy, your IT asset database could be permanently lost.

This guide shows you how to perform a full Backup Restore SnipeIT on Windows using XAMPP, including:

  • ✅ Manual backup (Files + MySQL database)

  • ✅ Automated backup using Windows Task Scheduler

  • ✅ Fast restore process via phpMyAdmin

  • ✅ Best practices for folder structure and retention

This tutorial works for:

  • Windows 10

  • Windows Server

  • XAMPP environments

By the end of this tutorial, you will confidently manage Snipe-IT backups on Windows safely and efficiently.


#1. Backup Manual

We start with manual backup configuration to ensure everything works correctly before automation.


Step 1: Edit file .env

Navigate to:

 
C:\xampp\htdocs\snipe-it

Edit the line:

 
DB_DUMP_PATH='C:\xampp\MySQL\bin'

This setting ensures Laravel knows where mysqldump is located inside XAMPP.


Step 2: Open CMD with Admin Rights

Run the following commands in order:

 
cd C:\xampp\htdocs\snipe-it php artisan config:clear php artisan config:cache

These commands refresh Laravel configuration and apply the new DB_DUMP_PATH.


Step 3: Restart XAMPP Services

Open XAMPP Control Panel:

  • Stop Apache

  • Stop MySQL

  • Start Apache

  • Start MySQL

This ensures the environment reloads properly.


Step 4: GUI Backup from Snipe-IT

Access Snipe-IT:

Admin ➜ Backup ➜ General Backup

When clicking General Backup, the system automatically generates a backup file in:

 
C:\xampp\htdocs\snipe-it\storage\app\backups

You can:

  • Click directly to download the backup

  • Or manually copy the file from app/backups

This file contains:

  • Full MySQL database dump

  • Uploaded files

  • Configuration data

At this point, your manual Backup Restore SnipeIT setup is complete.


#2. Backup Schedule (Automation)

Manual backup is useful, but automation ensures long-term protection.


Step 1: Create Backup Script

Create a folder in drive C:

 
C:\Script

Inside this folder, create a file named:

 
snipebackup.bat

Add the following content:

 
cd C:\xampp\htdocs\snipe-it php artisan snipeit:backup

This script triggers the Snipe-IT backup command.


Step 2: Create a Scheduled Task

Open:

Windows ➜ Task Scheduler

Create a new task and configure it to:

  • Run the snipebackup.bat file

  • Schedule based on your requirement (daily, weekly, etc.)

Recommended:

  • Run daily during low-traffic hours

  • Keep at least 7–30 days of backups

  • Store copies on external storage

With this, your Backup Restore SnipeIT process becomes fully automated.


#3. Restore

In case of system failure, database corruption, or migration, follow this restore procedure.

Access phpMyAdmin:

 
<IP Snipe>/phpMyAdmin

Example:

 
192.168.16.134/phpmyadmin

Step 1: Prepare backup.zip File

Ensure your backup file is ready.


Step 2: Import Database

Inside phpMyAdmin:

  • Select database snipeit

  • Click Import

  • Point to the backup.zip file

Start the import process and wait until completion.

This restores the full database structure and asset data.


Step 3: Restart XAMPP Services

Open XAMPP Control Panel:

  • Stop Apache

  • Stop MySQL

  • Start Apache

  • Start MySQL

After restart, access Snipe-IT again and verify:

  • Assets

  • Users

  • Licenses

  • Uploaded files

Your Backup Restore SnipeIT process is now complete.


🚀 Best Practices for Backup Restore SnipeIT

To ensure long-term stability:

  • Store backups outside htdocs when possible

  • Keep offsite copy (NAS / Cloud)

  • Monitor disk space regularly

  • Test restore process quarterly

  • Protect backup folders with proper permissions

A backup that has never been tested is not a real backup.


🔐 Final Thoughts

Mastering Backup Restore SnipeIT on Windows XAMPP ensures:

  • Business continuity

  • Reduced downtime

  • Secure IT asset management

  • Faster disaster recovery

Whether you are running Snipe-IT in production or internal IT tracking environments, implementing both manual and scheduled backups is essential.

With this setup, your Snipe-IT system is now protected, automated, and disaster-ready.

See also related articles

P13 – Ultimate QR Code SnipeIT Setup Made Easy

P13 – Ultimate QR Code SnipeIT Setup Made Easy SnipeIT – P13 QR Code Setup Guide | Create and Print Asset QR Codes Managing IT assets without proper labeling can quickly become chaotic.When devices move between departments, employees leave, or audits happen, identifying assets manually wastes time and increases errors....

Read More

P12 – Ultimate Bulk Method to Check In Check Out Assets in SnipeIT

P12 – Ultimate Bulk Method to Check In Check Out Assets in SnipeIT SnipeIT – P12 The Fastest Way to Check-In & Check-Out Assets in Snipe-IT (Bulk Method) Managing a few devices manually is easy. Managing 100–500 assets during onboarding, offboarding, or department transfers? That’s a different story. If you...

Read More

P11 – Ultimate Guide to Check In Check Out in SnipeIT

P11 – Ultimate Guide to Check In Check Out in SnipeIT SnipeIT – P11 How to Manage Check In Check Out in SnipeIT (Step-by-Step) Efficient asset tracking is the backbone of every IT department. If you cannot accurately manage Check In check Out in SnipeIT, your asset database quickly becomes...

Read More