To import sql file into existing database use the code below mysql -u[username] -p[password] [database_name] < [file.sql]
Author: contrib
Beanstalkd and Multiple Laravel Websites
If you have multiple websites on the same server using Beanstalkd for queues you can set unique queue tubes for each site to prevent jobs on the queue being triggered by the other sites. In Laravel, edit the queue config file and change default to something unique like the website name. ‘beanstalkd’ => [ ‘driver’ […]
Allow PHP Hook Script to Run for Git
Suppose we have a deploy.php script at /var/www/html/deploy.php that is called by a hook from a service such as Github or Bitbucket. We need to configure our web-server user, in this case it’s www-data, who’s default home directory is /var/www. Create .ssh directory and set permissions mkdir /var/www/.ssh chmod 0700 /var/www/.ssh chown -R www-data:www-data /var/www/.ssh […]
Pull Only 1 Directory From Git Repository
This can be done by setting up a sparse checkout. Sparse Checkout Create a directory mkdir [directory] Enter directory cd [directory] Git init and add remote git init git remote add origin [url] Enable sparse checkout git config core.sparseCheckout true Set folders to checkout in .git/info/sparse-checkout echo “[wanted directory]” >> .git/info/sparse-checkout Then pull the repository […]
SSH REMOTE HOST IDENTIFICATION HAS CHANGED
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that a host key has just been changed. The fingerprint for the RSA key sent by the remote host is If you […]
Proxy Settings for WordPress in config.php not working
Try installing/enabling the PHP Curl extension. apt-get install php5-curl
Allow remote access to MYSQL database
To allow remote access to MySql first create a MySql user and assign host as %. CREATE USER ‘newuser’@’%’ IDENTIFIED BY ‘password’; then grant privileges GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’%’; then flush privileges FLUSH PRIVILEGES; You may need to add the following to /etc/mysql/my.cnf to listen for all ip’s instead of […]