How to import an SQL file via HeidiSQL
Overview
Database management tools let you import pre-made SQL files that come with resources and frameworks. HeidiSQL is free and works great for this.
Recommended tools
HeidiSQL (free) or Navicat (paid, trial available). This guide uses HeidiSQL.
Step-by-Step Instructions
<ol><li>Click Databases in the control panel, then click the eye icon next to your database to reveal the credentials.</li><li>Launch HeidiSQL and click the New button at the bottom left to create a new connection.</li><li>Fill in the Hostname, User, Password and Port using the credentials from the panel, then click Open.</li><li>Select your database name in the left sidebar and open the Query tab.</li><li>Right-click the empty text field, choose Load SQL File and select your .SQL file (or paste its contents).</li><li>Press Play / F9 to execute. The query output should show "Query executed successfully".</li></ol>
Access denied?
Make sure you only connect to the database name you were given, and that you are using the exact credentials from the panel (no extra spaces).
FAQ
Related Tutorials
Was this guide helpful?
Join our Discord for more guides and direct help from our engineering team.