Skip to content

Instantly share code, notes, and snippets.

mikedamoiseau /
Last active Jun 14, 2022
Script to backup a MySQL database and send the dump by email and/or scp
# ----------------------------------
# DEFINED - Global variables
# ----------------------------------
# defined temporary folder
# database configure
mikedamoiseau /
Last active Mar 30, 2017
Script to automatically relaunch Nginx and MySQL servers
# date
DATETIME=$(date +%F_%T)
DATE=$(date +"%Y-%m-%d")
mikedamoiseau /
Created Oct 21, 2016
Wordpress project - setup script
# 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/
# The website will be installed in the `htdocs` folder
# if you can't execute the script, try `chmod +x ./`
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
And give the password. Better to use --ask-password so that the password is not saved in the history of the bash
mikedamoiseau / Leaflet with Google, Bing and Openstreet Maps
Last active Dec 10, 2021
Leaflet with Google, Bing and Openstreet Maps
View Leaflet with Google, Bing and Openstreet Maps
**Create a Bing API key**
**Download the plugins**
<!DOCTYPE html>
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
View git create branch from remote
git checkout -b nomDeMaBrancheDistante origin/nomDeMaBrancheDistante
fatal: git checkout: updating paths is incompatible with switching branches/forcing
Did you intend to checkout ‘origin/‘ which can not be resolved as commit?’
git remote update
mikedamoiseau / cakephp-last-executed-query
Created Jul 9, 2014
CakePHP - Display last executed SQL query
View cakephp-last-executed-query
$dbo = $this->Job->getDatasource();
$logs = $dbo->getLog();
$lastLog = end($logs['log']);
debug( $lastLog['query'] );
UP=$(pgrep mysql | wc -l);
if [ "$UP" -ne 1 ];
echo "MySQL is down.";
sudo service mysql start
echo "All is well.";
mikedamoiseau /
Last active Aug 29, 2015
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 your_detination_path/
# Import the database locally
gunzip filename.sql.gz | mysql -u [user] -p [password] [database]