Restore and take Backups of Database from shell
Postgresql Using following command you can take backup of postgresql database. # pg_dump -u -C -f backupfile.sql database_name You can restore pgsql database using following …
Latest articles for category: Database
Installing Postgresql
Installing Postgresql – HOWTO cPanel requires Postgresql 7.3.x or later. 7.2.x will not work. =========================================== Step 1 =========================================== Upgrade to cPanel 7.4.0 build 45 or …
Access your database remotely on a cPanel hosting
First of all, it is important to explain how the database/database user names are formed. The names consist two parts — your cPanel username and …
Fix the MYSQL ERROR: Client does not support authentication protocol
Solution This error is encountered by both scripts and applications, that are unable to use the new authentication protocol introduced by MySQL 4.1.x. The only …
Mysql gives error of access denied for root@localhost?
Solution Make sure root pass is in /root/.my.cnf This is usually the first root pass the box was given once cpanel is installed. If it …
Can you provide/recommend any tools for managing MySQL databases?
Solution: There is a multitude of administration tools ranging from ssh’ing into the server and directly issuing commands to commercial GUI software. phpMyAdmin is very …
How do I grant an MySQL user permission to a database?
Solution 1. Log into your cPanel ( https://www.yourdomain.com:2082). 2. Click on the “MySQL Databases” link. This will display the “MySQL Account Maintenance” screen. 3. Now …
CF DSN creation for MS Access fails
SYMPTOMS CF DSN creation for MS Access fails with the following error: Error sending request ot ColdFusion: 500 at (CCFExecutor::ExecuteRequest line 188) at execute C:\SWSoft\Plesk\/admin/bin/cfmng …
How do I modify PostgreSQL databases and user privileges?
You can edit the content of your databases and user privileges using the phpPgAdmin utility that comes with your control panel. To run phpPgAdmin, do …
How do I create PostgreSQL Users?
Unlike with other databases, a PostgreSQL database cannot be created without a user. You must stick to the following sequence: 1. Create a PostgreSQL user. …
How do I create/delete MS SQL databases?
Databases are created under logins and there can be several databases under one login. To create a MS SQL database, do the following: Click MS …
Showing 67 - 77 of 90 articles