How can we help you today?

How to use HeidiSQL on Hypernode

Created by: Lianne van Looij

Modified on: Fri, 29 May, 2020 at 1:51 PM


HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers (source: http://www.heidisql.com/).

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

TABLE OF CONTENTS

Download HeidiSQL

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

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 the MySQL hostname (see .my.cnf file)
    2. User: enter the MySQL user (see .my.cnf file)
    3. Password: enter the MySQL password for the user (see .my.cnf file)
  5. Leave all other fields as they are (image 1b).
  6. Click save in the bottom-left corner

(image 1)

Create a database dump

You should consider using Magerun, but you could use HeidiSQL to create a database dump.

  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.
L
Lianne is the author of this solution article.

Did you find it helpful? Yes No

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