How to connect to PostgreSQL from PHP?
For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function.
Continue Reading...How to import an .sql file into a Postgre database?
Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left tree menu and log in to the Postgre server using your cPanel login details. Next, select the database you want to import data into and click on the SQL button. You have two options. You can […]
Continue Reading...How to create a Postgre user?
In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases interface. In the Add New User form enter the username and password. Note that the username will always include your cPanel username as a prefix. Then you can add the newly-created username to an existing database. For this purpose […]
Continue Reading...How to create a Postgre database?
Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to your cPanel -> PostgreSQL Databases. In the Database Name: field enter the desired database name and click the Create Database button. Note that the database will always include your cPanel username as a prefix for the chosen database […]
Continue Reading...Is it possible to use a Postgre database for application installation?
It is possible to use a PostgreSQL database for all applications that support this database type. The installation is not in anyway different from installation using a MySQL database. You just need to specify the database type you are using. For example, in Drupal there is a radio button which you can use to specify […]
Continue Reading...How to access phpPgAdmin directly from my domain?
In order to access phpPgAdmin directly via your domain name without having to access your cPanel first, you need to install phpPgAdmin on your hosting account. The installation is very easy and consists of 3 simple steps: Download the latest version of phpPgAdmin. Upload the package to your public_html folder. Extract the package. By default […]
Continue Reading...How can I enable Mod-Rewrite Module?
In order to enable Mod_Rewrite for your site you should create a text file called .htacccess in the directory where you wish the rewrite rules to apply. The first line of this text file should be: RewriteEngine On After that you can place your rewrite rules. Here are some examples for Joomla’s SEF option: RewriteCond […]
Continue Reading...How to repair a MySQL database?
In this article we will show you two ways to repair a MySQL database. 1) Through cPanel: Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and then click the Repair DB button. If the database engine used […]
Continue Reading...How to change the database engine of a MySQL database table?
In this article we will show you how to change the database engine of a MySQL table. Let’s assume that you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB. The MySQL query that should be used is: ALTER TABLE my_table ENGINE = InnoDB; […]
Continue Reading...