Skip to content

Instantly share code, notes, and snippets.

@mikedamoiseau
mikedamoiseau / mysql-import-export.sh
Last active Aug 29, 2015
Mysql database import/export with command line
View mysql-import-export.sh
# 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]
View monitor.sh
#!/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
View 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
View laravel-ums.markdown

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 Sep 22, 2015
How to download a folder with all its content recursively using wget
View wget-download-ftp-recursive-folder
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
View todo-after-install-ubuntu.md

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 Dec 31, 2015
Plugins for a good and secure Wordpress website
View wordpress-plugins
## 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/)
View PHP Countries Array
<?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 Oct 21, 2016
Wordpress project - setup script
View wp-setup.sh
#!/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 Mar 30, 2017
Script to automatically relaunch Nginx and MySQL servers
View relaunch-services.sh
#!/bin/bash
#settings
EMAIL="me@example.com"
SUBJECT="THE EMAIL SUBJECT"
# date
DATETIME=$(date +%F_%T)
DATE=$(date +"%Y-%m-%d")