Database

How to create a MySQL or MariaDB database

Manual

A database is a set of data belonging to the same context and stored systematically for subsequent use. Any website containing data that can be queried through a search tool on the site itself or that allows entering data via a text form needs a database (...)

Error establishing a database connection in WordPress

Manual

When you visit a dynamic web page (for example, developed in PHP), the system usually connects to a database (DB) to obtain the information that must be displayed on the screen. Unlike static pages (such as those created solely in HTML), dynamic pages gene (...)

How to access phpMyAdmin from the SWPanel

Manual

What is phpMyAdmin? phpMyAdmin is a DB manager. It is a tool used to manage (create, modify, delete...) any record of your databases through a web interface. How to access phpMyAdmin? You can access phpMyAdmin from your SWPanel; you will only need to know (...)

How to import and export DBs with phpMyAdmin

Manual

Database Import with phpMyAdmin To import your website's database to your new hosting on SWPanel, you must follow these steps: 1. First, you must access your SWPanel and enter the name of the hosting service you wish to configure in the top search window. (...)

How to open port 3306 in Plesk

Manual

To perform a complete migration from another Hosting provider to SW Hosting, it is essential that port 3306 —used by MySQL databases— is open. This manual details the necessary steps to enable port 3306 in Plesk. Step 1: Access the domains section Once you (...)

How to open port 3306 in cPanel

Manual

To perform a complete migration from another Hosting provider to SW Hosting, it is essential that port 3306, which corresponds to MySQL (database), is open. In the following manual, we will show how to open port 3306 in cPanel and allow access to SWHosting (...)

How to Import an SQL file to my Database in SWPanel with HeidiSQL

Manual

With SWPanel you can use the phpMyAdmin tool to access the management of your databases, such as exporting or importing them. Also, you can use any type of application for the management of MySQL/MariaDB Databases, such as HeidiSQL, which allows for a much (...)

How to delete a MySQL or MariaDB Database

Manual

To delete a MySQL or MariaDB Database from SWPanel, you must follow these steps: Access the dashboard of the hosting service where the database is created. You can use the top search bar of your SWPanel info_capture The screenshot is for guidance pur (...)

How to import a database via SSH

Manual

In this manual, we will teach you how to import a database (MySQL) to your Cloud server via SSH, for example, a Cloud SWPanel Smart Web D5. This is useful if the import via phpMyAdmin fails or any other issue occurs when uploading the database. 1. Environm (...)

How to Import a SQL file to my Database in SWPanel with DBeaver

Manual

With SWPanel you can use the phpMyAdmin tool to access the management of your databases, such as exporting or importing them. Also, you can use any type of application for database management, such as DBeaver which allows for much more powerful DB manageme (...)