Skip to content

Instantly share code, notes, and snippets.

@m00dawg
m00dawg / keybase.md
Created January 18, 2017 10:47
keybase.md

Keybase proof

I hereby claim:

  • I am m00dawg on github.
  • I am sweetums (https://keybase.io/sweetums) on keybase.
  • I have a public key whose fingerprint is 24DD B07D 83EB 157F 4A3B DF3E 0100 AACD 688A 03BE

To claim this, I am signing this object:

### Keybase proof
I hereby claim:
* I am m00dawg on github.
* I am sweetums (https://keybase.io/sweetums) on keybase.
* I have a public key whose fingerprint is FA81 CA0C 44C1 2175 D634 AB04 1162 E54D 78C6 150B
To claim this, I am signing this object:
root@mcp:~# cat /etc/drizzle/drizzled.cnf
datadir = /var/lib/drizzle
pid-file = /var/lib/drizzle/mcp.pid
[mysql-protocol]
port = 3307
bind-address = 127.0.0.1
root@mcp:~# /etc/init.d/drizzle-server start
DROP DATABASE test;
CREATE DATABASE test;
USE test;
CREATE TABLE t1 (num1 SERIAL) ENGINE='InnoDB';
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
INSERT INTO t1 VALUES ('');
CREATE VIEW v1 AS SELECT * FROM t1;
[root@holland ~]# mysql -uroot -p`cat /root/pwfile`
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.1.47-ius Distributed by The IUS Community Project
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
[root@holland default]# grep backups-to-keep /etc/holland/backupsets/default.conf
backups-to-keep = 1
[root@holland default]# du -sch *
48M 20100623_044729
48M 20100623_044759
95M total
[root@holland default]# tail -n50 /var/log/holland/holland.log | grep -B4 "Ending backup run"
2010-06-23 04:47:42,140 [INFO] Executing: /usr/bin/mysqldump --defaults-file=/var/spool/holland/default/20100623_044729/my.cnf --max-allowed-packet=256M --lock-tables world
[root@holland ~]# holland bk default
Holland 0.9.9 started with pid 3166
-----> Starting backup run <----
Acquired backup lock.
Loading config for backupset default
Loading plugin mysqldump
Prepared backup spool /var/spool/holland/default/20100428_105209
Loading /root/.my.cnf [/root/.my.cnf]
Loading ~/.my.cnf [/root/.my.cnf]
Estimated Backup Size: 204.10MB
[root@285992-app2 ~]# holland bk --dry-run
Holland 0.9.8 started with pid 25676
-----> Starting backup run <----
Acquired backup lock.
Loading config for backupset default
Loading plugin mysqldump
Prepared backup spool /var/spool/holland/default/20100506_175708
Running in dry-run mode
Unexpected exception caught. This is probably a bug. Please report to the holland development team.
Traceback (most recent call last):