Note Great circle distance Great circle distance Find the distance in kilometres between two points on the surface of the earth. This is just the… Read More »Distance between two points (given the latitude/longitude of those points) FUNCTION for MySQL
GRANT SHOW DATABASES, SELECT, LOCK TABLES, RELOAD ON *.* to backup@localhost IDENTIFIED BY ‘password’; FLUSH PRIVILEGES; Note Create a specific user for backups purpose with… Read More »MySQL permissions for backup
Note : Dans tous les cas, ajouter l’option -p si un mot de passe est nécessaire après le nom du compte. Dans les exemples, on… Read More »Insérer un fichier SQL sur un serveur Apache Windows (dans Wamp ou EasyPhp)
mysqldump -h localhost -u user -ppassword -r/tmp/mysql_backup.data nomdatabase mysql -h localhost -u user -ppassword nomdatabase < /tmp/mysql_backup.data
mysql -u root -p mysql> show databases;
Note By default, MySQL’s datadir is placed in the /var/lib/mysql directory. However, if you are planning on using MySQL tables to store a lot of… Read More »Moving the MySQL’s datadir directory
Note a partir de mysql 5.0 SELECT TIMESTAMPDIFF(DAY,‘2005-01-02’,‘2006-01-08’);
#!/bin/bash prefixe=backup suffixe=$(date +%Y%m%d) filename=$prefixe$suffixe.sql host=host database=database user=user characterSet=UTF8 mysqldump –skip-comments \ –complete-insert \ –default-character-set=$characterSet \ –no-create-info \ –skip-add-locks \ –skip-opt \ –host $host \… Read More »mysql_backup.sh
# Enable mysql> SET GLOBAL general_log = ‘ON’; # On Debian, you can check log on /var/run/mysqld/mysqld.log tail -f /var/run/mysqld/mysqld.log # Disable mysql> SET GLOBAL… Read More »Enable/Disable MySQL Log
#terminal C:\>mysql -uroot -p mysql> SELECT version(); # cliente mysql SELECT version();