cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
Note: These shortcuts are valid for Zsh’s emacs
mode, not necessarily
for vi
mode.
Shortcut |
Description |
M-. |
insert the last word from the previous history entry |
C-u |
kill the current line |
C-v C-j |
insert newline at current cursor position |
C-x C-e |
edit current command line in $EDITOR |
C-x C-f char |
move to the next occurrence of character char |
cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
From the MySQL
manual:
The binary log contains “events” that describe database changes such as
table creation operations or changes to table data. It also contains events
for statements that potentially could have made changes (for example, a
DELETE
which matched no rows), unless row-based logging is used. The
binary log also contains information about how long each statement took that
updated data.
The binary log is primarily needed for master-slave-setups and data recovery
operations. Files are never deleted and pile up in the datadir
(e.g. /var/lib/mysql
), named mysqld-bin.000001
, mysqld-bin.000002
, …
(Alternatively, the files might be named hostname
-bin.000001
, …)
To get rid of them, run the following two commands as MySQL’s admin user:
mysql> FLUSH LOGS;
mysql> RESET MASTER;
The first command flushes unsaved transactions to the database, and the second
one deletes all binary logs.
If you do not need the binary logs at all, you can also disable them entirely
by removing the log-bin
option from your my.cnf
configuration file.
cheat-sheet articles are about code
snippets that I need every once in a while, and which I constantly forget
about.
First, register your nickname if you haven’t done so yet:
/msg NickServ REGISTER my_password my.email.address@example.com
Login (“identify”) with NickServ:
/msg NickServ IDENTIFY my_nick my_password
Next, register your channel:
/msg ChanServ REGISTER #my-channel
Change the channel’s topic:
/msg ChanServ TOPIC #my-channel my_topic
If the channel is not very frequented, you might want to set the KEEPTOPIC
flag. Otherwise, you have to re-set the topic every time:
/msg ChanServ SET #my-channel KEEPTOPIC ON
Hide information about the channel from other users:
/msg ChanServ SET #my-channel PRIVATE ON
Restrict the channel to user’s who are on the channel’s access list:
/msg ChanServ SET #my-channel RESTRICTED ON
Add and remove users to the access list—only registered user accounts are
allowed:
/msg ChanServ ACCESS #my-channel ADD other_user
/msg ChanServ ACCESS #my-channel DEL bugging_user
Display access list:
/msg ChanServ ACCESS #my-channel LIST