How can we help you today?

Support Portal Categories

How to use HeidiSQL on Hypernode

Modified on: Thu, 1 Jul, 2021 at 7:42 AM

HeidiSQL is a useful and reliable tool designed for web developers. It lets you easily manage your database, enabling you to browse and edit data, create and edit tables, views, and databases. You can also easily export and download structure and data either to a backup, SQL file, or to other servers.

HeidiSQL is a tool that runs on Windows 8, and 10. It can also be used on Linux, using wine.

This article will explain where to download and how to use HeidiSQL with your Hypernode.


Download and Install HeidiSQL

First, go to the HeidiSQL homepage and use the installer to install the latest version of HeidiSQL.

Add your IP to the allowlist

By default, your MySQL server is protected by a firewall. If you wish to connect remotely, you will need to add your IP address to the allowlist. You can find your IP address by typing in 'what is my ip' into Google.

Configure HeidiSQL

Then configure HeidiSQL as follows:

  1. Start HeidiSQL
  2. Click new in the bottom-left corner
  3. Choose a suitable name for your connection
  4. Edit the following fields. 
    1. Hostname / IP: enter your hypernode
    2. User: enter the MySQL user (Usually 'app')
    3. Password: enter the MySQL password for the user (see .my.cnf file)
  5. Leave all other fields as they are.
  6. Click save in the bottom-left corner

Create a database dump

You should consider using Magerun, but you could use HeidiSQL to create a database dump. Please note that making a dump through HeidiSQL may generate an inconsistent backup, as data may change while your backup is created. 

  1. Start HeidiSQL.
  2. Connect to your Hypernode.
  3. Use Tools -> Export database as SQL.
  4. In the left pane, choose the Magento database.
  5. Choose a filename to export to.
  6. Choose appropriate options, notably data.
  7. Press Export.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.