How to free disk space from MySQL ibdata1

Problem description MySQL uses several files for journaling transactions, among these files there is the ibdata1 file. Due to the way MySQL stores its data, this file can grow very large and unfortunately cannot simply be removed without risking corruption and/or data loss. How to find the root cause The most likely cause are one […]

Read more

How to use HeidiSQL

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 […]

Read more

How to use MySQL on Hypernode

This article explains how to use MySQL on Hypernode, from finding your credentials, whitelisting your IP address to using phpMyAdmin. Finding your credentials Your MySQL credentials are stored in the homedir of application user. You find them in the file .my.cnf located in /data/web.

What you should know There is no predefined database, so […]

Read more

How to use phpMyAdmin

This article will explain how you can use PHPMyAdmin and how to create a database dump. By default it is accessible at http://appname.hypernode.io/phpmyadmin For protection, phpMyAdmin by default is only accessible through the appname.hypernode.io/phpmyadmin URL, on Vagrant via the appname.hypernode.local/phpmyadmin url and on Docker through YourBaseURL/dbadmin after you followed these instructions. You can adjust this behaviour […]

Read more