MySQL Notes

From myWiki
Revision as of 12:38, 13 June 2016 by Stevet (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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]