ZhoubaWiki:DBDumpingProcess

From ZhoubaWiki
Revision as of 16:31, 22 May 2021 by Garak (talk | contribs) (Created page with "* MySql ==> $ mysqldump -u db-user -p --add-drop-database --single-transaction --databases db-name |gzip > db-name.sql.gz <== ungzip the dump $ mysql -u db-user -p <...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  • MySql

==>

 $ mysqldump -u db-user -p --add-drop-database --single-transaction --databases db-name |gzip > db-name.sql.gz

<==

ungzip the dump

 $ mysql -u db-user -p < db-name.sql