MySQL Notes: Difference between revisions
Created page with "Backing up from the command line $ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql] Compressing backup $ mysqldump -u [uname] -p[pass] [dbname] | gzip..." |
No edit summary |
||
| Line 15: | Line 15: | ||
gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname] | gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname] | ||
Sample Python code snippet: | |||
<syntaxhighlight lang="python" line='line'> | |||
def quickSort(arr): | |||
less = [] | |||
pivotList = [] | |||
more = [] | |||
if len(arr) <= 1: | |||
return arr | |||
else: | |||
pass | |||
</syntaxhighlight> | |||
Revision as of 15:02, 22 August 2018
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