If you're a UK2 customer looking to manage your databases with advanced tools like MySQL Workbench, this article will guide you through the process of connecting to a UK2-hosted database using Remote MySQL Access. While the integrated phpMyAdmin tool ...

Connecting To MySQL Remotely

You can use phpMyAdmin to import an .SQL file with your database information. To do this: Login to StackCP by following this guide Click phpMyAdmin in the Web Tools section Click Sign In next to the database you wish to import the .SQL file into. ...

How Do I Import a Database via phpMyAdmin

Database maintenance is something that every database/web administrator should practice. An optimised and well-managed database can be the difference between a responsive website, and one that appears sluggish, simply because queries are able to be ...

How do I Optimise and Reduce the Size of my Database?

There are various ways to export your MySQL databases for safe keeping or transfer. The first method allows you to back up multiple databases via your My20i control panel and the second on a 'per database' basis via phpMyAdmin. Backup/Restore The ...

How To Backup Your Database

You can create MySQL databases in seconds directly from your StackCP control panel. This option is unavailable for packages hosted on our WordPress platform due to its WP-optimised nature. If you need to create a MySQL database, you'll need to carry ...

How to create MySL Databases

The Error Establishing Database Connection error is one of the most commonly experienced errors on WordPress sites. The error itself indicates that the connection between your website files and the database has dropped. As the database is queried for ...

How to fix the "Error Establishing Database Connection" in WordPress

phpMyAdmin is a free, web-based tool designed to help you manage MySQL databases easily. With phpMyAdmin, you can create, edit, delete, and back up databases and tables without needing to use complex command-line instructions. It provides a ...

How To Use PHPMyAdmin

If you've set up SSH access for a package then you can use one of two methods to import a MySQL database via the CLI. If needed, please see our guide on how to connect to your package via SSH. MySQL CLI To import a SQL file via the command line, you ...

Working with a Database