This guide shows you how to restore database_filename.sql into the database_name database.
- Open your terminal (or SSH into your server if needed).
- Navigate to the folder where your SQL file is located:
cd /path/to/your/sqlfile - Run the MySQL import command:
mysql -u your_username -p database_name < database_filename.sql - Enter your MySQL password when prompted.
Once completed, the data from database_filename.sql will be successfully imported into the database_name database.
