Skip to content

Instantly share code, notes, and snippets.

@mikedamoiseau
mikedamoiseau / mysql-import-export.sh
Last active August 29, 2015 14:01
Mysql database import/export with command line
# Export the database to a file
mysqldump -u YourUser -p 'UserPassword' YourDatabaseName | gzip > wantedsqlfile.sql.gz
# Make a local copy the file from the server
scp user@xxx.xxx.xxx.xxx:/path_to_your_dump/filename.sql.gz your_detination_path/
# Import the database locally
gunzip filename.sql.gz | mysql -u [user] -p [password] [database]
#!/bin/bash
UP=$(pgrep mysql | wc -l);
if [ "$UP" -ne 1 ];
then
echo "MySQL is down.";
sudo service mysql start
else
echo "All is well.";
fi
@mikedamoiseau
mikedamoiseau / git create branch from remote
Created July 11, 2014 05:14
git create branch from remote
git checkout -b nomDeMaBrancheDistante origin/nomDeMaBrancheDistante
if
```
fatal: git checkout: updating paths is incompatible with switching branches/forcing
Did you intend to checkout ‘origin/‘ which can not be resolved as commit?’
```
then
```
git remote update

There's no shortage of good resources for learning laravel. So instead of the usual introductory tutorial were just gonna learn Laravel by building a project from scratch and that's gonna be a User Management System.

I don't know if my definition of a User Management System is correct but here's my idea of what's it's capable of doing:

  • Register Roles
  • Register Users
  • Update Users
@mikedamoiseau
mikedamoiseau / wget-download-ftp-recursive-folder
Created September 22, 2015 08:14
How to download a folder with all its content recursively using wget
Use this command line:
wget -r -nH --cut-dirs=3 -nc --ftp-user=jfc-ftp --ask-password ftp://jfc.bitbakers-kunden.de//htdocs/wp-content/uploads
And give the password. Better to use --ask-password so that the password is not saved in the history of the bash

Things to do after install Ubuntu

  • Update all packages
  • Install Unity2D
  • Install Vim sudo apt-get install vim
  • Change default editor to be Vim editor-select
  • Install Google Chrome http://www.google.com/chrome
  • Customize terminal prompt .bashrc and .vimrc
  • Install LAMP sudo apt-get install tasksel
  • Install PHPMyAdmin sudo apt-get install phpmyadmin
@mikedamoiseau
mikedamoiseau / wordpress-plugins
Last active December 31, 2015 14:19
Plugins for a good and secure Wordpress website
## Security
Captcha
All In One WP Security
Wordpress Login Delay
## SEO
Google XML Sitemaps
SEO Friendly Images
All In One SEO Pack OR Yoast
Far Future Expiration Plugin (this one cannot be installed from the search plugin functionality: http://www.tipsandtricks-hq.com/)
<?php
$countries = array("Afghanistan", "Albania", "Algeria", "American Samoa", "Andorra", "Angola", "Anguilla", "Antarctica", "Antigua and Barbuda", "Argentina", "Armenia", "Aruba", "Australia", "Austria", "Azerbaijan", "Bahamas", "Bahrain", "Bangladesh", "Barbados", "Belarus", "Belgium", "Belize", "Benin", "Bermuda", "Bhutan", "Bolivia", "Bosnia and Herzegowina", "Botswana", "Bouvet Island", "Brazil", "British Indian Ocean Territory", "Brunei Darussalam", "Bulgaria", "Burkina Faso", "Burundi", "Cambodia", "Cameroon", "Canada", "Cape Verde", "Cayman Islands", "Central African Republic", "Chad", "Chile", "China", "Christmas Island", "Cocos (Keeling) Islands", "Colombia", "Comoros", "Congo", "Congo, the Democratic Republic of the", "Cook Islands", "Costa Rica", "Cote d'Ivoire", "Croatia (Hrvatska)", "Cuba", "Cyprus", "Czech Republic", "Denmark", "Djibouti", "Dominica", "Dominican Republic", "East Timor", "Ecuador", "Egypt", "El Salvador", "Equatorial Guinea", "Eritrea", "Estonia", "Ethiopia", "Falkland Island
@mikedamoiseau
mikedamoiseau / wp-setup.sh
Created October 21, 2016 10:05
Wordpress project - setup script
#!/bin/bash
# This setup script is to be used for new Wordpress project setup
# The file structure should be like this:
# /var/www/root-folder-project
# |_ /htdocs/
# |_ /dev/setup.sh
#
# The website will be installed in the `htdocs` folder
# if you can't execute the script, try `chmod +x ./setup.sh`
@mikedamoiseau
mikedamoiseau / relaunch-services.sh
Last active March 30, 2017 14:53
Script to automatically relaunch Nginx and MySQL servers
#!/bin/bash
#settings
EMAIL="me@example.com"
SUBJECT="THE EMAIL SUBJECT"
# date
DATETIME=$(date +%F_%T)
DATE=$(date +"%Y-%m-%d")