Skip to content

Instantly share code, notes, and snippets.

View n8kowald's full-sized avatar

Nathan n8kowald

  • Australia
  • 14:43 (UTC +09:30)
View GitHub Profile
@n8kowald
n8kowald / gist:2634432
Last active June 25, 2021 04:36
Useful SQL Queries
--SQL REPLACING
UPDATE mdl_message SET message = REPLACE(message, "target_view.phpcourse", "target_view.php?course") WHERE message LIKE('%target_view.phpcourse%');
--SQL Backup and Restore
--BACKUP
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
--RESTORE
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
--CREATE TABLE
@n8kowald
n8kowald / gist:2634304
Last active January 31, 2017 15:23 — forked from maciakl/gist:1584387
Git Workflow
# GIT WORKFLOW
# (c) Luke Maciak
# Initialize:
git init
# Check Out:
git clone username@host:/path/to/repository
# Add Origin: