To take backup database, you need to execute following command:
mysqldump -u root -p password db_name > /tmp/sql_file.sql
And you can import/restore database using following command:
mysql -u root -p password db_name < /tmp/sql_file.sql
mysqldump -u root -p password db_name > /tmp/sql_file.sql
And you can import/restore database using following command:
mysql -u root -p password db_name < /tmp/sql_file.sql
No comments:
Post a Comment