Skip to content

Instantly share code, notes, and snippets.

@luisfc

luisfc/Import and export tables in MySQL

Last active January 14, 2019 21:01
Show Gist options
  • Save luisfc/2b818598c2f1977d09566e16ced3e41d to your computer and use it in GitHub Desktop.
Save luisfc/2b818598c2f1977d09566e16ced3e41d to your computer and use it in GitHub Desktop.
Download ZIP
Import and export tables in MySQL
Raw
Import and export tables in MySQL
#Generating table backup:
mysqldump databaseName tableName > backup.sql -u user -p
#Restore table backup:
mysql -u root -p databaseName < backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment