How to Import a Database via phpMyAdmin in cPanel
Log in to your cPanel account. In the Databases section, click on phpMyAdmin. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. Click on Import. Under File to Import, click on Browse and select SQL file from your computer. Scroll down and click on Go. If it shows a success message, your SQL has been successfully uploaded.
How to Subscribe to an Invoice via PayPal
You can subscribe to an invoice for recurring payments. The subscription option is only available if you are purchasing a recurring service and the invoice due date is in the future. Log in to your hosting client area. Go to the Invoices section, open the unpaid invoice you want to subscribe to, and make sure you set the payment method as PayPal. Click on the PayPal Subscribe. PayPal asks you for login details. Enter your PayPal credentials and click Log in. Choose an appropriate payment source, such as your Debit Card or another method and confirm with Continue. Check the details carefully and click Agree & Subscribe. If everything goes right, the system notifies you that you paid the money and created a subscription. If it shows a link to Return to Merchant, click on it, and in case it is not working, you can close the browser window.
How to Remove Sample Comments and Posts From WordPress
You get sample comments and posts in a fresh WordPress install. You can easily remove them in the following way. Log in to the WordPress dashboard. From the Dashboard menu, go to Posts and click on All Posts. Hover the mouse on the sample post and click on Trash. Now, do the same with the sample pages. Head to the Dashboard menu, hover your mouse on Posts, and click All Posts. Remove the sample pages. Similarly, you can remove sample comments. Choose Comments from the dashboard, hover your mouse over a comment and choose Trash. After you take these steps, your blog will be clean from sample comments and posts.
How to Set the PHP Version per Directory in cPanel
Do you want to use different PHP versions per directory? You can do this using cPanel and the dot htaccess file. Log in to your cPanel account. In the Software section, click on MultiPHP Manager. The first thing we need to do is to get the code generated by cPanel. Scroll down to the bottom of the page. Select your domain from the left side of the screen. You can view the PHP Version from the drop-down menu on the right. Please, select the appropriate PHP version from it and click on Apply. First, open the /public_html/.htaccess file in the cPanel File Manager, and you will find the code generated by cPanel. After you copy the code, should you wish to set the PHP to version 8 in the directory forums, create a .htaccess file in the directory /forums/ and paste the code generated in the previous step. Congratulations, now