how to take mysqldump and restore

MysqlDump And Restore

A Database Backup Program. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server.

mysqldump command :-




# mysqldump  -u  user_name  -p  database_name  >  database_name.sql

Now check the database_name.sql file use below command.

# ls

MysqlRestore Command :-

Note :- before restore mysql dump need to already created blank database in mysql.

#  mysql  -u  user_name  -p  database_name  <  database_name.sql