ZhoubaWiki:DBDumpingProcess

From ZhoubaWiki
Jump to: navigation, 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