MIAS Training & User Manual
Practical guidance and step-by-step tutorials for handling core MIAS operations — including database backup, restoration, and maintenance procedures.
Exporting Database Backup
To create a backup, open phpMyAdmin, select the MIAS database, and click on the Export tab. Choose SQL format and press Go to download the complete database file. This file can be stored for safety and used later for restoration.
Learn Export Steps →Restoring Backup Data
To restore data, open phpMyAdmin, create or select a database with the same name, and go to the Import tab. Choose your saved .sql backup file and click Go. This will re-create all tables and records as per the saved backup.
Restore Now →Safe Storage & Best Practices
Always store your database backups in a secure folder outside the XAMPP directory, and keep a copy in cloud storage like Google Drive or OneDrive. Maintain weekly backups and name them with date and version for easy tracking.
Backup Tips →🎯 Goals & Objectives of Training
The MIAS training module ensures users gain confidence in managing, backing up, and operating the system efficiently. It bridges the gap between system setup and real-time execution.
Hands-on Practice
Step-by-step video and document-based tutorials for each MIAS operation.
Easy Understanding
Visual and practical guides designed for non-technical department staff.
Data Safety & Reliability
Focus on secure handling of database backups and user credentials.
Frequently Asked Questions
How to take a MySQL backup using phpMyAdmin?
Go to phpMyAdmin → Select Database → Click Export → Choose SQL Format → Click Go.
Where should I store my database backup?
Store in a secure folder outside XAMPP directory and optionally upload to cloud storage like Google Drive.
How to restore a database?
Go to phpMyAdmin → Create or Select Database → Click Import → Choose .sql file → Click Go.
How often should backups be taken?
At least once per week or before any major system update.