If you regularly access databases on the command line, or if you want to run SQL commands from a script, then you might want to…
Category: Databases
Knowledgebase articles about databases, including phpMyAdmin.
Why innodb_file_per_table is important
Although the InnoDB storage engine has many advantages over MyISAM, there are some downsides as well. One disadvantage you may have encountered is that InnoDB…
Converting MyISAM and InnoDB tables
Changing the storage engine for a database table is surprisingly easy, but there are a few things to be aware of. This article looks at…
Advantages of InnoDB over MyISAM
There are quite a few storage engines available for MariaDB. As at June 2021 the default storage engine is InnoDB. However, cPanel servers still use…
Exporting and importing databases from the command line
Most of our servers use cPanel, which has an excellent interface for working with databases. However, sometimes it is better to instead use the command…
Creating a database in cPanel
This article talks about creating a MySQL/MariaDB database via cPanel. Other articles in this section include:
Managing existing databases in cPanel
You can manage existing databases via the MySQL Databases page. You can use this page for the following actions:
Accessing your database remotely
By default, you can only access your databases via the server hosting your website. cPanel’s Remote MySQL page lets you enable database access from other…
phpMyAdmin overview
phpMyAdmin is an open source tool that lets you work with databases via your web browser. The software is not developed by cPanel but included…
phpMyAdmin examples
This article looks at a few practical phpMyAdmin use-cases. If you are new to phpMyAdmin you might want to read our phpMyAdmin overview first.