Hello Guys,
How to create backup and restore the backup?
Create Mysql Backup Process :-
If you want to back up a single database, you merely create the dump and send the output into a file, like so:
mysqldump database_name > database_name.sql
Multiple databases can be backed up at the same time:
mysqldump –databases database_one database_two > two_databases.sql
It is also simple to back up all of the databases on a server:
mysqldump –all-databases > all_databases.sql
Restore Process:-
If you want to restore a single database, like so:mysql database_name < database_name.sql
If you are trying to restore a single database from dump of all the databases, you have to let mysql know like this:
mysql –one-database database_name < all_databases.sql