How to load a big SQL file
mysql -u database_username -p -D database_name < public_html/sql_uploads/your_sql_file.sql
Category: CentOS
Common services started from the command prompt
Restarting Services From the Command Line
How to start CentOS Web Panel
service cwpsrv status service cwpsrv start https://www.plothost.com/kb/services-centos-web-panel/
Adding users with root privileges
https://unix.stackexchange.com/questions/174780/centos-7-add-new-user-with-root-privileges
firewalld – Trouble connecting to services? Timing out? Probably the firewall
firewall-cmd –list-ports firewall-cmd –list-services firewall-cmd –list-all firewall-cmd –add-port==132/tcp –permanent firewall-cmd –reload —————————- systemctl enable firewalld systemctl start firewalld systemctl status firewalld https://www.liquidweb.com/kb/how-to-start-and-enable-firewalld-on-centos-7/
Occupied port – killing processes
https://stackoverflow.com/questions/39322089/node-js-port-3000-already-in-use-but-it-actually-isnt https://stackoverflow.com/questions/14790910/stop-all-instances-of-node-js-server
Install with root
sudo npm install @material-ui/icons –unsafe-perm=true –allow-root
Permissions
File sever sudo chmod -R 757 /var/www Local host sudo chown -R $USER .*
Delete all files and directory / in directory
Delete all files and directory rm -rf dir1 Delete all files in directory rm -rf dir1/*
Copy all files and subdirs in directory
For this example I’m transferring files from ‘test’ into ‘server’ cp -rf /home/server/folder/test/* /home/server/