AKZN Notes

Archives for My Lazy and Forgetful Mind

Category: CPanel

How to import big table using mysql command on terminal

Understanding the MySQL Import Command with Custom Parameters When importing large SQL dump files into MySQL, it is often necessary to adjust MySQL’s configuration parameters to handle large queries and improve performance. The following command is an example of importing a database dump while customizing MySQL’s memory settings and disabling foreign key checks: "D:\xampp\mysql\bin\mysql" –max_allowed_packet=512M […]

Deploy from GitHub to cPanel Using Webhook and Deployment Hook (No SSH Key)

Step 1: Set Up Git Version Control in cPanel: Log in to your cPanel account. Navigate to the "Git Version Control" section (or similar) and create a new repository or choose an existing one. Note down the repository URL provided by cPanel. This URL is used to push changes. Step 2: Configure GitHub Webhook: In […]

Deploy Laravel Project to Hosting or VPS

Deploy to CPanel Clone git to cpanel Taken from https://dashboard.webhostingmagic.com/knowledgebase/242/How-To-Clone-A-Private-Github-Repo-To-A-cPanel-Server.html Git private repository requires SSH access. So you must ensure that your hosting package has SSH enabled (customers on Web Hosting Magic need not worry as every hosting package comes with SSH access) and perform additional steps in order to successfully clone a privately-hosted remote […]