Databases
How to import/export a MySQL database
1 - In cPanel, go to “PhPMyAdmin”; Import: 2 - Click on "Import"; 3 - Click the "Choose File or File" button and select your database (.sql); 4 - Click the "Execute" button; Export: 2 -Choose the database you want to export from the list on the left; ...
Remote Dtabese Access
Add a specific domain name or IP to allow visitors to connect to MySQL databases. Step 1Logged into your cPanel in the “Database” section, locate the “Remote MySQL” item. Step 2 Now enter the hostname (domain, server or IP address). The wildcard ...
PostegreSQL Databases
To use a database, you will need to create it. Only PostgreSQL users with privileges to access a database can read or write to that database. How to create and add a user to the PostgreSQL database Step 1 Logged into your cPanel in the “DATABASE” ...
MySQL Database
MySQL databases are required to run many web-based applications, such as information dashboards, content management systems, and online shopping carts. Step 1 Logged into your cPanel, in the DATABASE tab, locate the item “Manage My Database” note: ...
How to associate the user with the PostgreSQL Database
To associate a user with a PostgreSQL database in cPanel, follow the detailed steps below: 1. Access cPanel: Log in to your cPanel account. 2. Go to the Databases section: On the cPanel home page, locate the "Databases" section. Click on "PostgreSQL ...
How to Synchronize User Privileges - PostgreSQL
To synchronize user privileges - PostgreSQL in cPanel, you can follow these steps: 1. Access cPanel: Log in to your cPanel account. 2. Navigate to the Databases section: Find and click on the "PostgreSQL Databases" section. 3. Create or select a ...
How to create a PostgreSQL database
Here is a step-by-step guide to creating a PostgreSQL database on your hosting. 1. Login to cPanel: Access cPanel using your user credentials and password provided by your hosting provider. 2. Locate the “Databases” section: In the main cPanel ...
How to create a user for PostgreSQL database
Here is a step-by-step guide to creating a user for your PostgreSQL database 1. Login to cPanel: Access cPanel using your user credentials and password provided by your hosting provider. 2. Locate the “Databases” section: In the main cPanel ...
How to create a PostgreSQL database
Here is a step-by-step guide to creating a PostgreSQL database on your hosting. 1. Login to cPanel: Access cPanel using your user credentials and password provided by your hosting provider. 2. Locate the “Databases” section: In the main cPanel ...
How to import/export a PostgreSQL database
Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...
Creating a MySQL Database
The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "Databases" ...
How to connect to firebird database on hosting
In this example, we will show you how to connect the Firebird database. First you must access a database manager. Enter the information according to the image below. Host/Server: Your hosting domain. Path: the full path to the bank location, example: ...
How to create firebird database on your hosting
In this example, we will show the creation of a Firebird database. First you must access your cPanel: See how to obtain credentials and access cPanel through our article: ...
How to create and change the Firebird password
In this example, we will show you how to create and change the Firebird database password. First you must access your cPanel: See how to obtain credentials and access cPanel through our article: Here Within cPanel, you must click on the item ...
How to upload a firebird database to your hosting acount
If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...
Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"
This error occurs when the database needs to search on more than 1 million rows to meet he requirements of your query. This limitation does not concern the number of records in a table,but rather how many records will be read to satisfy a query, so ...
Import a CSV file to MYSQL in PHPMYADMIN
Step 1 First you must access your cPanel and go to the "phpMyadmin" item in the Database Section; Step 2 - In PHPMyAdmin, go to the menu "Import"; Step 3 - Select CSV format Step 4 - Click "Choose file", and search for local file and select CSV ...
How to access PhpMyAdmin in your hosting?
When hosting with Scriptcase, phpMyAdmin is already installed as standard, you just need to access it through cPanel. See how to access cPanel : Aqui phpMyAdmin is a SQL database manager where you can make changes to your database. - Through cpanel ...
How to import a database in PhpMyAdmin?
Step 1 1 - In cPanel, go to “PhPMyAdmin”; Step 2 In the top bar of your PHPmyadmin click on "Import"; Click the "Choose File or File" button and select your database (.sql); Step 3 Then correctly define the settings you want for import as in the ...
How to export your database in phpMyAdmin?
To export your database on phpMyadmin, you must access phpMyadmin through cPanel. - You must choose the database you want to export. - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...
How to create a VIEW in phpMyAdmin?
To create a View in phpMyadmin, you must first access phpMyadmin through cPanel. 1. Click on a table, it is located on the left side, as the following image: 2. Then you click on "View". Then "Create View". 3. You will be presented with a form to ...
How to create Procedure in phpMyAdmin?
To create a Procedure in phpMyadmin, you must first access phpMyadmin through cPanel. 1. Click on your database which is located on the left side, after that, click on "Routines". 2. Then click on "Create new Routine". 3. Fill in the data and ...
How to create a table in PhpMyAdmin?
To create a table in phpMyadmin, you must first access phpMyadmin through cPanel. - Click on the database you want to create the table, which is located on the left side; - Now click on "Create table", type the name of the table and the number of ...
How to change database charset - MySQL
To change the MySQL charset, follow these steps: 1. Access the cPanel: Log in to your cPanel account. 2. Access phpMyAdmin: In cPanel, find the "Databases" section and click on "phpMyAdmin". 3. Select the Database: In phpMyAdmin, on the left panel, ...
How to restore Firebird backup from the terminal?
To restore the backup of your Firebird database, you must first access the Terminal through the cpanel in "Advanced" and then click on "Terminal". Once you have the Terminal open, you will enter the following commands: gbak -user YOUR_USER -pas ...