Skip to content

Instantly share code, notes, and snippets.

@2arunpmohan

2arunpmohan/mysql: create and restore sql dump files.md

Last active January 5, 2019 12:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 2arunpmohan/a70eca2d585c7c60e81f667497d88228 to your computer and use it in GitHub Desktop.
Save 2arunpmohan/a70eca2d585c7c60e81f667497d88228 to your computer and use it in GitHub Desktop.
Download ZIP
how to create and restore sql dump files - command line
Raw
mysql: create and restore sql dump files.md

create dump files

mysqldump -u root -p test_arun > /home/user/Desktop/test_arun_dump.sql

Restore dump files

mysql -u root -p test_arun_restored < test_arun_dump.sql

for this, we need to create the database "test_arun_restored" prior to to the ececution of the command
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment