Find the answers you need
Support Database
Category: Databases
In this section
Building a MySQL instance on CentOS 7
You might need a larger database - for large ecommerce stores or complex sites, for example. To do …
How to fix the ‘Error Establishing Database Connection’ in WordPress
The Error Establishing Database Connection error is one of the most commonly experienced errors on WordPress sites. The error itself …
How do I connect to my database via .NET?
A website built using .NET can be connected to databases of different types: MySQL, MSSQL, and Access databases. You …
How do I restore a site using Timeline Backups?
You can easily restore lost data using the Timeline Backups tool which you can order from within your 20i …
How do I optimise and reduce the size of my database?
Database maintenance is something that every database/web administrator should practise. An optimised and well-managed database can be the difference …
What is MariaDB?
MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL. This makes …
How do I import a .sql file via phpMyAdmin?
You can use phpMyAdmin to import an .SQL file with your database information. To do this: Log in to …
How do I check MySQL Database sizes across packages in My20i?
20i provides an easy way to monitor and view all MySQL database sizes across all packages in your My20i …
What’s the cost of a Microsoft SQL database?
For Microsoft SQL databases, there is a £9.99 monthly charge for a 1GB database. This covers the Microsoft licensing cost. …
How do I import a .sql file via the command-line?
If you've set up SSH access for a package then you can run the following command-line instructions …
Can I set my database hostname as ‘localhost’?
No, you would need to set the database hostname as the server that it's on at 20i. You can …
Does ‘Back Up Multiple Sites’ back up databases?
Yes. You can back up multiple sites from the Back Up Web Hosting icon under the Reseller Manager section …
How do I download or back up my MySQL Database?
There are various ways to export your MySQL databases for safe keeping or transfer. The first method allows you to …
How do I manage my Microsoft SQL database?
We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases. This industry-standard software provides …
How do I create a MySQL database in My20i?
You can create MySQL databases in seconds directly from your My20i control panel. This option is unavailable …
What’s the maximum MySQL database size allowed?
At 20i, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise …
What is MS-SQL?
Microsoft SQL Server is a relational database management system (RDMS) developed by Microsoft. As a database …