sed magic, including explanation

5 Feb

sed one-liners explained, this one is outstanding: Famous Sed One-Liners Explained, Part I: File Spacing, Numbering and Text Conversion and Substitution stumbled upon this while trying to paginate text with (gnu) sed, aka reformatting text to a given line width. … Read More »

MySQL backup user

20 Jan

to create a user for doing automated backups of a MySQL installation that doesn’t have more than the necessary privileges, use the following statement: GRANT RELOAD, SELECT, LOCK TABLES ON . TO ‘backup’@‘localhost’ IDENTIFIED BY ‘some_reasonable_password’;