How to find the correct path of a working php.ini on a cPanel server
1. Login to the SSH with root user 2. Use the command as php -i | grep php.ini 3. This will output the path to …
Latest articles
How to Enable Gzip, GD, and MySQL in cPanel
1. Login to the WHM 2. At your left hand side Menu search for Easy Apache, Click on it 3. Keep the configuration as it …
Disable directory browsing for the website on cPanel server
1. Log into WHM 2. Service Configuration –> Apache Configuration 3. Global Configuration 4. Scroll down to Directory ‘/’ Options 5. Un-tick Indexes option 6. …
How to Restore the Individual cPanel Account via SSH?
Step 1: To restore the cPanel account backups, enter the following command /scripts/restorepkg username [Note: In order to restore the data, you need to be …
How to create backup of Individual cPanel Account via SSH?
1: Log-in to the SSH as Root user. 2: Enter the following command string on the command line interface: /scripts/pkgacct username [Note: The account backup …
How to Fix cPanel Error: Sorry the Domain is Already Set Up
If your cPanel account is giving you the error “Sorry the domain is already set up,” it’s probably due to one of two different reasons. …
Create a database user through the MySQL CLI
Through the mysql command line, this is accomplished by running the following commands. In SSH, type “mysql” to access the mysql command line. Then type: …
Backup a database from the shell prompt
Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script. Create a full backup of your database: shell> …
Use the Load DATA statement?
After creating your table, you need to populate it. The LOAD DATA and INSERT statements are useful for this. Suppose that your pet records can …
Secure the initial MySQL accounts?
Securing the Initial MySQL Accounts Windows distributions contain preinitialized grant tables that are installed automatically. On Unix, the grant tables are populated by the mysql_install_db …
Change ownership of a table through MS SQL
DECLARE @old sysname, @new sysname, @sql varchar(1000) SELECT @old = ‘oldOwner_CHANGE_THIS’ , @new = ‘dbo’ , @sql = ‘ IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES …
Showing 452 - 462 of 1347 articles