Skip to content

Instantly share code, notes, and snippets.

@pixelpogo

pixelpogo/gist:4510898

Created January 11, 2013 14:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pixelpogo/4510898 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pixelpogo/4510898 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. pixelpogo created this gist Jan 11, 2013.
    9 changes: 9 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    An example:

    During the import of a big sql-dump MySQL encountered an error in Line 8131086:
    ERROR 1449 (HY000) at line 8131086: The user specified as a definer ('foo'@'%') does not exist

    To fix that problem I had to have a look at this specific line and, to get the context, ten lines before and after that line.
    This is how I did it:

    $ sed -n '8131076,8131096p' ~/Downloads/dump_2012-12-17.sql