Skip to content

Instantly share code, notes, and snippets.

View peppyheppy's full-sized avatar

Paul Hepworth peppyheppy

View GitHub Profile
@peppyheppy
peppyheppy / gist:1249816
Created September 29, 2011 02:09 — forked from avalanche123/gist:981817
GitHub Emoji
:+1:
:-1:
:airplane:
:art:
:bear:
:beer:
:bike:
:bomb:
:book:
:bulb:
#!/bin/bash
# Connects to a MySQL database to dump data in batches.
# Great for dumping large datasets.
LIMIT=1000000
OFFSET=0
MAX_ROWS=1000000000
# This loops until it has read MAX_ROWS