backups don't make me money

Post on 18-May-2015

334 Views

Category:

Technology

1 Downloads

Preview:

Click to see full reader

DESCRIPTION

Backups aren't exciting or glamorous. They don't make you money and there's no such thing as a valid backup. But, understanding your restores is exciting! Let me draw you a few pictures of database restores at their most ironic, entertaining, and even thrilling.

TRANSCRIPT

“Backups don’t make me money”

- CTO, client.

http://www.flickr.com/photos/vitamindave/

I have blueprints,

and the fabrication drawings.

http://www.flickr.com/photos/chicagogeek/

http://www.flickr.com/photos/adactio/

http://www.flickr.com/photos/stevecadman/

http://www.flickr.com/photos/cdharrison/

-- MySQL dump 10.13 Distrib 5.1.44, for pc-linux-gnu (i686)---- Host: localhost Database: mysql-- -------------------------------------------------------- Server version 5.1.44-community-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Current Database: `schema`--CREATE DATABASE /*!32312 IF NOT EXISTS*/ `schema` /*!40100 DEFAULT CHARACTER SET latin1 */;USE `schema`;

Importing with mysql -d schematest< schemadump.sql

doesn’t help

http://www.flickr.com/photos/johnjoh/

<3 xkcd.com

http://www.flickr.com/photos/gongus/

http://www.flickr.com/photos/stallio/

http://www.flickr.com/photos/frield/

http://www.flickr.com/photos/philliecasablanca/

http://www.flickr.com/photos/matijagrguric/

http://www.flickr.com/photos/myklroventine/

Oh, and the CTO from the opening slide?

http://www.flickr.com/photos/gemstone/

http://www.flickr.com/photos/amagill/

http://www.flickr.com/photos/laffy4k/

sarah@bluegecko.net@sarahnovotny@bluegecko

top related