2arunpmohan
8/24/2017 - 2:36 PM

how to create and restore sql dump files - command line

how to create and restore sql dump files - command line

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