Table of Contents


Wiki

Applications

Firefox

Homepage: http://www.mozilla.com/firefox/
Add-ons: https://addons.mozilla.org/en-US/firefox/

Add-ons

My preferred add-ons:

Feeds, News & Blogging

NewsFox

Web Development

MeasureIt

Download Management

Download Statusbar
FireFTP
FoxTorrent
PDF Download

Privacy & Security

Adblock Filterset.G Updater
Adblock Plus
NoScript

Search Tools

CustomizeGoogle
HighlightAll

Interface Customizations

All-in-One Gestures
All-in-One Sidebar
Cooliris Previews
Fast Dial
FishEyeTabs
Informational Tab
PermaTabs
Speed Dial
Yet Another Smooth Scrolling

Bookmarks

Foxmarks Bookmark Synchronizer

Language Tools

Dictionaries

Photos, Music & Videos

FireShot
Image Toolbar
PicLens

Social & Communication

Gmail Manager

Alerts & Updates

Update Notifier
Viral Threat Level

Other

FEBE
Print Context Menu
StatusbarEx
TrashMail.net

Keepass

RDP association

Install “Bureau à distance Microsoft” depuis le Microsoft Store

Open Keepass and go to: Tools → Options → Integration → URL Schema Overrides

Click on “Add” button

Type “rdp” in the schema box, and past the snippit below into the URL Override box.

cmd: cmd /c “cmdkey /generic:TERMSRV/{URL:RMVSCM} /user:{USERNAME} /pass:{PASSWORD} && start /b mstsc /v:{URL:RMVSCM} && timeout /t 5 /nobreak && cmdkey /delete:TERMSRV/{URL:RMVSCM}” Now, when you add a server, enter the URL as rdp:server.domain.com

Patterns for password generator

PatternWithMinusPassword

[A^\I\O\Y\Z\l\y\z\0\1]{5}\-[A^\I\O\Y\Z\l\y\z\0\1]{5}\-[A^\I\O\Y\Z\l\y\z\0\1]{5}\-[A^\I\O\Y\Z\l\y\z\0\1]{5}\-[A^\I\O\Y\Z\l\y\z\0\1]{5}\-[A^\I\O\Y\Z\l\y\z\0\1]{5}

PatternWithSymbolsPassword

[A^\I\O\Y\Z\l\y\z\0\1]{5}[\#\-\$]{1}[A^\I\O\Y\Z\l\y\z\0\1]{5}[\#\-\$]{1}[A^\I\O\Y\Z\l\y\z\0\1]{5}[\#\-\$]{1}[A^\I\O\Y\Z\l\y\z\0\1]{5}[\#\-\$]{1}[A^\I\O\Y\Z\l\y\z\0\1]{5}[\#\-\$]{1}[A^\I\O\Y\Z\l\y\z\0\1]{5}

SinglewordPassword

[\#\-\$]{1}[d^\0\1]{1}[A^\I\O\Y\Z\l\y\z\0\1]{15}

check “Randomly permute characters of password”

Change the default algorithm for password generator

Go to Tools / Generate Password On the Settings tab, select the profile you want Click the save button to the right of the profile name It will ask for the name of the profile to save to, select (Automatically generated passwords for new entries) and click OK Click OK again and try it!

MySQL

Database Management

Check Tables Indexes

check table %TABLE% for upgrade;

Check Tables for Errors

mysqlcheck --all-databases -u root -p

Create User and Database

mysql> create database DATABASENAME;
mysql> grant all privileges on DATABASENAME.* to 'USERNAME'@'LOCALHOST' identified by 'PASSWORD';
mysql> flush privileges;
mysql> exit

Get Table List

show tables;

Get Table Size

show table status;

Get Database List

show databases;

Repair Corrupted Table

mysql -u root -p
mysql> use databasename; 
mysql> REPAIR TABLE tablename;

Select Database

use %DATABASENAME%

SQL Profiler

Activate or deactivate the profiler for the current session:

set profiling=1;
set profiling=0;

Display queries ID and durations:

show profiles;

Display query informations:

show profile for query %QUERYID%;

Display query information details:

show profile %VALUE% for query %QUERYID%;

where %VALUE% can be: ALL, CPU, BLOCK IO, CONTEXT SWITCHES, IPC, PAGE FAULTS, SOURCE or SWAPS.

Command-line Client

Normal login:

mysql -D %DATABASENAME% -u %USERNAME% -p

Execute script:

mysql -D %DATABASENAME% -u %USERNAME% -p < %SCRIPTFILE% > %OUTPUTFILE%

Get Current State

show status like '%PARAMS%%';

Transaction Log Management

Purge log files (with MySQL replication):

mysql -u root -p -e "PURGE BINARY LOGS BEFORE '2011-5-13 10:06:06';"

SQL statement:

FLUSH LOGS

Unix command line:

mysqladmin flush-logs

Replications

Check Status

show slave status \G;

Start

slave start;

Postgress

Backup

Crontab user postgres:

00 23 * * * /%PATHTOSCRIPT%/backuppostgres.sh >>/dev/null

Script:

DATE=$(date +%Y-%m-%d)
pg_dump DBNAME | gzip > /data/backup/DBNAME_${DATE}.gz

Command Line Client

su postgres
psql -d %DATABASENAME%

Get All Tables Names

SELECT tablename FROM pg_tables

Get All Databases

psql -l

VMWare

Remove Snapshots

vmware-cmd /vmfs/volumes/%VMFSSTORAGE%/%VMNAME%/%VMNAME%.vmx removesnapshots

Rename VMDK File

/usr/sbin/vmkfstools -E %OLDNAME%.vmdk %NEWNAME%.vmdk

ToDo

http://www.commentcamarche.net/faq/9773-reinitialiser-le-mot-de-passe-root-de-mysql

mysqladmin status

Calculate Total Database Index Size

mysql -u mysqlusername -p -e “SELECT CONCAT(ROUND(SUM(index_length)/(1024*1024), 2), ' MB') AS 'Total Index Size' FROM information_schema.TABLES WHERE table_schema LIKE '%DATABASE%';”

Calculate the Total Size of Table Data

mysql -u mysqlusername -p -e “SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024), 2), ' MB') AS 'Total Data Size' FROM information_schema.TABLES WHERE table_schema LIKE 'databasename';”