Backing-up and Restoring databases in MySQL is a very straight forward process using the terminal.
mysqldump -u [username] --password=[passwd] [database] > [file].sql
This will create the file in the same directory. This is basically a text file and can be opened using any text editor.
mysql -u [user_name] --password=[your_password] [database] < [file_name].sql
This will restore all the data and tables to the existing Database that has been mentioned.
mysql -u [user_name] --password=[your_password] < [file_name].sql
Simply skipping the name of the existing database will create the new one based on the
[file_name].sql file provided.
To can skip the
–password=[your_password] in all of these commands with
-p switch and it will ask for the password later. From a security point of view this would be better as password as plain text won’t be stored in the