How to use HeidiSQL

in MySQL Tags: MySQL

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 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 1).

    Use HeidiSQL

    Use HeidiSQL

  6. Click save in the bottom-left corner

Create a database dump

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

  1. Start HeidiSQL.
  2. Connect to your node.
  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.

1