MySQL Notes
Backing up from the command line
$ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]
Compressing backup
$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]
Restore from command line
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Restoring compressed backup
gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]
Sample Python code snippet:
def quickSort(arr):
less = []
pivotList = []
more = []
if len(arr) <= 1:
return arr
else:
pass
SELECT
*
FROM
table
WHERE
(clause)
;