The PHP scripting language is a popular method of accessing your MySQL database via the web. Here is a sample program using PHP explaining each function.
How to secure your database
There are scenarios where databases can become vulnerable to hackers. These situations can be prevented by securing scripts and MySQL statements.
How to convert from MS-Access to MySQL
How to convert your database from MS-Access to MySQL is explained here:
How do I convert my PostreSQL database to a MySQL database?
We explain how you can move database platforms by converting the syntax used in creating the database from PostreSQL to MySQL.
What does database administration involve?
Database Administration involves the overall design and management of databases. This is something that your appointed web developer can assist you with.
MySQL indexes for database optimization
If you are looking into troubleshooting the performance of a database and the queries that run on it, you can make use of the MySQL feature, MySQL indexes.
How to change your Database Password
It is good practice to change your passwords regularly to prevent unauthorised access to your information. Change your Database Passwords via konsoleH Browse to konsoleH and…
How to Repair or Optimise a Database
Databases associated with your hosting account can easily be repaired if they become corrupt or optimized if they are large using phpMyAdmin in konsoleH.
How to Update Database Connection strings
We recommend that you use the File Manager in konsoleH to retrieve the configuration file. Alternatively, an FTP program such as FileZilla or CuteFTP.
Can MySQL triggers, functions, stored procedures or views be added to a MySQL database?
Since the migration to MySQL version 5.1, clients can now make use of MySQL features on a MySQL database hosted on our managed hosting platform.
How to export a MySQL database via phpMyAdmin
Using our step-by-step visual guide you can export MySQL database via the phpMyAdmin tool within konsoleH. We show you how.
How to import your database via phpMyAdmin
Use the phpMyAdmin tool within konsoleH to import a copy of your MySQL database to your hosting account.
How to export a database via SSH
Using our easy to follow guide, you’ll be able to export MySQL database via command-line, by using SSH. Before exporting, enable SSH for your domain.
How to import a MySQL database via SSH
You can now import your MySQL database via command-line using SSH by following the steps provided in our Help Centre guide.
How to view the database allocation on your Managed server
We provide the steps to view your Managed server database list, and the domains to which the respective databases belong to.
Create and manage a MySQL/MariaDB Database
MySQL databases are managed via your konsoleH control panel using the Manage MySQL tool.