How to get mysql Database dump and restore database
Hello,
1.You can use following commands for taking mysql dump in .sql format
go to /var/lib/mysql
search for the database whose dump you want.
ls -l | grep database_name
mysqldump database_name > database.sql
2. If the mysql dumpis available and you want to restore that you need to use following command for that
cd /var/lib/mysql
check the database name where you want to restore the mysqldump
ls -l | grep database_name
mysql database_name < database.sql
