Let’s assume you are importing a SQL backup file for a website called exampleblog.com.ng.
🧾 Step-by-step Commands:
📂 This moves you into the folder where your .sql.gz file is stored.
🗜 This command unzips exampleblog_dbbackup.sql.gz into a usable SQL file: exampleblog_dbbackup.sql.
🔁 This imports the uncompressed SQL file into the MySQL database named exampleblog_db.
🔐 Note: You’ll be prompted to enter the MySQL root password before the import begins.
✅ Summary of Variables Used:
| Variable | Example Used | Explanation |
|---|---|---|
| Domain | exampleblog.com.ng | The website’s domain name |
| SQL Backup File | exampleblog_dbbackup.sql.gz | Compressed database file |
| MySQL Database Name | exampleblog_db | The database into which you’re importing |
| MySQL Username | root | Administrative MySQL user |