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 |